Page 1 of 1

left join and certain fields

Posted: Tue Apr 05, 2005 2:07 am
by 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

Posted: Tue Apr 05, 2005 2:52 am
by feyd
that's controlled by your SELECT statement.