Sort data from 2 tables ?!?!

wxdqz

New Member
Hi,

i have a problem with sorting data from 2 tables:

tableA id time text
1 10:10 welcome
2 10:14 welcome2

tableB id time text
1 10:12 bye
2 10:15 bye2

How can i set a mysql command that order by time form tableA and tableB at the same time.

select * from tableA, tableB order by time;

doesn't work!

solution
1 10:10 welcome
1 10:12 bye
2 10:14 welcome2
2 10:15 bye2

thx 4 help
 
Back
Top