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