left join and certain fields

[pelegk2]

when i use a left join in a query how can i get only a certain field from the "left joined table" and not all the fields?
is it possible?
thnaks in advance
peleg

[mrhappiness]

SELECT 
  t1.field2, t2. field7,
  t2.field78
FROM table1 t1
  LEFT JOIN table2 t2 ON t1.id = t2.t1_id

you mean something like that?

[pelegk2]

does this mean that only 3 field will be in the record set and not al the fields of table2?

[Drakla]

in Mr's example there would be three fields, one from table 1 and two from table 2.

You can pick whatever fields you like for the result set.

Mr has used aliases of the table names calling table1 t1 and table2 t2, you don't always have to do that but it's very helpful, and the only way to do a join on a table with itself.

If you are joining 2 or more tables and they have fields with the same name you have to resolve the ambiguity by naming the fields in the

table.field

format.