[eluser]Mat-Moo[/eluser]
I've got a query that runs over multiple tables which returns a fair bit of data (single row though). One of the key fields is ID which is then used else where, however one of the secondary tables also has a ID which is different, and because the field name is the same, the resulting data shows the secondary data not the first.
Adding lots of selects for each table with all the fields I require is possible but not ideal as there is a LOT of fields being returned
Any other ideas of how I can get around this?
