MySQL JOIN with results from single table

Question

I'm looking to join tableA with tableB to get a series of resulting data.

I need the JOIN with tableA and tableB to ensure I get the correct values from tableA, however, I don't want any of the values from tableB when I fetch the results.

I appreciate that I can do the following:

SELECT a.col1, a.col2, a.col3 FROM tableA AS a etc

I'm looking for a neater way, maybe with some cool new keyword I haven't come across before? (Here's hoping).

Thank you in advance.

Select * is not necessarily a [good way](http://stackoverflow.com/questions/65512/which-is-faster-best-select-or-select-column1-colum2-column3-etc) — Tim Lehner, Mar 22 '12 at 20:53
@Tim Interesting post. Largely unimportant for my project at this stage though. — Alex, Mar 22 '12 at 21:10

score 2 · Answer 1 · answered Mar 22 '12 at 20:50

2

you can either name out all of your fields:

SELECT a.col1, a.col2, a.col3... 
FROM tableA a
JOIN tableB b
    on a.id = b.id

or just use you table alias a.*

SELECT a.* 
FROM tableA a
JOIN tableB b
    on a.id = b.id

answered Mar 22 '12 at 20:50

Taryn

234,956
54
359
399

score 1 · Accepted Answer · answered Mar 22 '12 at 20:48

1

If you want all columns from table a, just use a.*:

SELECT a.* FROM tableA AS a etc

answered Mar 22 '12 at 20:48

alexn

55,635
14
110
143

Perhaps with `distinct` reserved word? – dani herrera Mar 22 '12 at 20:49

score 1 · Answer 3 · answered Mar 22 '12 at 20:49

1

select a.* FROM tableA a JOIN tableB b ON a.b_id = b.id;

answered Mar 22 '12 at 20:49

Ray

38,399
19
91
131

MySQL JOIN with results from single table

3 Answers3