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.

Oleg Dok · Accepted Answer · 2012-01-16T09:51:04.610

5

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

SELECT DISTINCT t1.*
from T1
join t2 on condition

edited Jan 16 '12 at 09:51

answered Jan 15 '12 at 08:45

Oleg Dok

1

Consider adding the `DISTINCT` keyword. – onedaywhen Jan 16 '12 at 09:36
1

@onedaywhen yep, thanx. And surely better use EXISTS instead of JOIN – Oleg Dok Jan 16 '12 at 09:51

score 3 · Answer 2 · answered Jan 15 '12 at 08:45

3

first_table.* should do the trick.

answered Jan 15 '12 at 08:45

score 2 · Answer 3 · edited May 23 '17 at 10:24

2

Sounds more like a semi join. Consider rewriting e.g.

SELECT DISTINCT T1.*
  FROM T1 JOIN T2 ON T1.id = T2.id;

can be re-written as

SELECT *
  FROM T1
 WHERE id IN (SELECT id FROM T2);

edited May 23 '17 at 10:24

Community

answered Jan 16 '12 at 09:36

onedaywhen

3 Answers3