Hi & thanks for the advice.
I think I have found a solution - the SELECT I need this for is for a 2 table join where both tables have column name id. I realised that SELECT * was much faster than SELECT field1, field2, field3 etc..... So I wanted to use * for both speed and simplicity - but then had the problem of having 2 'id' fields returned (I don't want and didn't need the id from the second table as I already had the value as table2_id held in table1 - this was used to join the 2 tables).
So I did a bit of research and came up with the following (which works) : -
Although this keeps the Query nice and neat, do you think it will also be quicker than defining each individual column in the SELECT ??
SELECT Table2_Wanted_Field, Table1.* FROM Table1, Table2 WHERE Table2_id=Table2.id';