Works. Thanks. I appreciate the help.

>You prefix '*' with table/alias name the same way as you prefix other fields.

OPEN DATABASE "C:\Program Files\microsoft visual foxpro 8\Samples\Tastrade\Data\tastrade.dbc"
>SELECT tb1.*, tb2.english_name, tb3.* ;
>	FROM products tb1  ;
>		JOIN products tb2 ON tb2.product_id = tb1.product_id ;
>		JOIN products tb3 ON tb3.product_id = tb1.product_id
>

>>How can I mix and match the "*" with a field list, including all fields from some tables with selected fields from others?
>>
>>I have tried using an alias in front of the "*", both with and without a . in between the alias and the * but keep getting errors.
>>
>>Would appreciate any help. TIA, Chuck