Here is my consternation.
I have multiple tables that I need to query.
They all share a 'month' column.
I will query them all based upon month that comes from a
request.querystring("monthID")

I need to loop through that various 'sets' of data seperate from each
set
ie.
- display all of data from table1 then somewhere else on my .asp page
display all of the data from table2, and so on.

My Table names are:
articles
sponsors
events
systems

How do I do this?

I have been able to join multiple tables but I am stumbling around in
the dark as what method/process I should be using to display my
actuall data as I need to.

I have tried using multiple SELECT statements but I think that is the
wrong way to do so since I do have a common filed for all the tables
(month)

I could use help with the SELECT statement (JOIN/SHAPE??) and then how
to write the data to my .asp page.


I will be most grateful for clarity on this matter.