joining recordsets: possible?

[cwarner]

is it possible to join recordsets?

if not, can I create temporary tables
and join them?

should I use the 'SELECT INTO' to create
a temporary table?

any sample code would be great, thanks in advance!

-Christy-

 

[beetee]

You might want to learn about UNION queries. It's a way of combining two tables; you can open a recordset based on a union query.

Here's some sample SQL from a union query I used recently:
[tt]
SELECT EmpName, EmpID, SS_Number, TermDate, Date, Points, EmpAutoNumID, AwardName, Step FROM Report_EmployeeAwards
UNION ALL SELECT EmpName, EmpID, SS_Number, TermDate, Date, Points,EmpAutoNumID, "Payment", null FROM Report_EmployeeWithdrawals
ORDER BY EmpName, Date;
[/tt]