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
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