[SOLVED] can you do multiple tables?

[SirChick]

Can you do multiple tables in one query ?

 

I have 3 tables which all have a time stamp and the user's ID and was hoping to get all rows from all 3 tables and sort them in ASC order by the time stamp... just curious how you collect multiple tables...? Ive only ever done multiple fields in a query.

 

Hope you can enlighten me

[benjaminbeazy]

use a join

http://dev.mysql.com/doc/refman/5.0/en/join.html

[SirChick]

So i would do :

 

SELECT * FROM t1 LEFT JOIN (t2, t3)
                 ON (t2.time=t1.time = t3.time GROUP BY time ASC )

 

Something like that?

[benjaminbeazy]

somethng similar to that, i've only used join a couple times. i think it is more like

 

ON (t2.time=t1.time AND t1.time = t3.time GROUP BY time ASC )

 

but i could be totally wrong about that.

[Barand]

Sounds more like a UNION is required

 

SELECT id, timestamp FROM t1
UNION
SELECT id, timestamp FROM t2
UNION
SELECT id, timestamp FROM t3
ORDER BY timestamp