Displaying Multiple Categories (from seperate tables) to be viewed on one page

Hello.

I just created separate tables for each of my categories and wanted to know how to return them all to be viewed on one page using the SQL Datasource (or whatever) This is for user accounts. I just need to know that part.

Sincerely,

Computergirl

use UNION ALL

select * from table1

union all

select * from table2