Jump to content

order two tables by the date field


alejandro52

Recommended Posts

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

 

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.