>Hi guys
>
>I seem not to understand the proper use of the * in Sql Select Syntax especially where JOINS exist. How can I use it to select ALL FIELDS from the LEFT JOIN and just One or Two Fields from the RIGHT JOIN or Vice Versa. Whenever I use it, the output ends up will ALL fields from ALL Tables.
>
>Thanks in advance
>
>Fred Matano

Select aa.*,bb.field1 from aa left join bb ....