Is there some way to select the first table without writing all the fields names in the query?

Question

Q: If I have two tables joined together, and I want to get (*) from the first table, I mean all the fields of the first table.

Shall I write all the fields names of the first table in the query? Or is there some way to select * just from the first table.

Answer 1

You should not to list all the fields, see the example:

SELECT DISTINCT t1.*
from T1
join t2 on condition