Combining tables

[billybrag]

Hi all,

Im trying to pull data from 2 similar tables and output it as 1.

For example these are my tables

alertID
alertTitle
AlertDesc
AlertCategory
dateAlertAdded
and

contentID
contentTitle
ContentDesc
ContentCategory
dateContentAdded

so I want to grab all the data and combine it in date order so they are like 1 table when outputted so i can have them on a single page

[r937]

use UNION ALL

[billybrag]

will that allow me to loop over the results all in one?

[r937]

of course

[DarthGuido]

Use UNION