multiple selects

[Anon]

I need to select the contents of two tables and order them by date. Is this possible without using a temporary table - so that I can select all from table1 and table two and order them by a common dateposted?

Thanks

Frans

[brandonschnell]

something like:

SELECT * from table1,table2 WHERE table1.dateposted LIKE table2.dateposted ORDER BY table1.dateposted

[steved]

This will only give you the rows where the same date is in both tables. If you have a date in one table but not the other, it won't show up in your record set. It would be better to drop the WHERE clause and just do a straight select.