Union Query for just one field 1

[molly]

Is it possible to make a Union Query in the SQL qry mode to obtain 1 common field that exists in 2 queries ?
I have a RawID in my Usage qry and a RawID in my Purchases Qry. I would like to make a new Qry to combine and make unique the RawID. So far I tried:


Select * from [UsageQry].[OldRawID]
UNION Select * from [PurchasesQry].[OldRawID];

If this works, My next plan was to use this Union Qry like a bridge or junction to the UsageQry and PurchasesQry so that I see their data based on a RawID.

Ideas? thanks so much.

 

[fneily]

Would you mind posting your table structures? example:
tblUsage
UsageID
etc.

tblPurchases
PurcharseID
etc.

Other tables.

 

[dhookom]

Have you tried:

Select [OldRawID] 
from [UsageQry]
UNION 
Select [OldRawID] 
from [PurchasesQry];

Duane
Hook'D on Access
MS Access MVP

 

[molly]

Duane - your method worked perfectly.
I will donate again shortly.
thanks MOlly