order two tables by the date field

[alejandro52]

I have two tables and i want to order them by date field.Both have the same fields.But when i use

$query = 'SELECT * FROM table1,table2 ORDER BY date DESC'; 

it says Query failed: Column 'date' in order clause is ambiguous.

[alejandro52]

anyone?

[fenway]

First, that's going to produce MxN rows, which is not what you want.  Sound you want a UNION.

[teng84]

it says Query failed: Column 'date' in order clause is ambiguous.

 

i guess that error is telling you that the field also appear on the other table in your table 1 or 2 you have the same field name use an index to avoid that

 

something like

 

order by table1.date,table2.date

 

[fenway]

Actually, if you did the union, it wouldn't be ambigious anymore, because you'd have to decide if you wanted their order within the tables or overall.