I need to select data from two, and eventually three, mysql tables at once, but I'm having trouble finding info that would help this particular case. What I need to do is select columns containing date values (column names month, date, year) from multiple tables and mix and order them as if I were pulling them from one table and using ORDER BY to line them up. For example the following data is in the dbase:
table1.month = 11
table1.day = 7
table1.year = 2001
table1.month = 1
table1.day = 19
table1.year = 2002
table2.month = 12
table2.day = 5
table2.year = 2001
I need to have it select each of those fields from each table, and order them like so:
1-19-2002
12-5-2001
11-7-2001
Can anyone point me in the right direction for what SQL statement I need to use for this?
Thanks.
