Is there a way to combine the results of two tables. Sort of mixing one in with the other. I basicaly have two tables that store different info. One has guests the other attendees, and most of the time them being seperat is fine.<BR><BR>In this case however I am trying to get an alphabetical listing of everyone from both tables. The data I will be pulling exists in colums in both tables (firstName, LastName stuff like that). Is there a way i can basicaly combine the results of what is really two queries into one sorted dataset?