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