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