query to combine tables

[galantis]

Hi,
help!
I have problem to solve. I have a table which gives
Module, Site CC, Description,ContractHrs,Quantity
PR06,5110000,1" XS CS,0,0
PR06,5110001,1" SCH 160 CS,0,0
PR06,5110002,1" XXS CS,0,0
PR06,5110003,1.5" XS CS,0,0
PR06,5110004,1.5" SCH1 60 CS,0,0
PR06,5110005,1.5" XXS CS,0,0
PR06,5110006,2" XS CS,0,0
PR06,5110007,2" SCH 160 CS,7.656,17.4
PR06,5110008,2" XXS CS,0,0
PR06,5110009,3" STD CS,35.616,67.2
PR06,5110010,3" SCH 80 CS,14.098,26.6
etc

and another table which gives
Module, Site CC, Description,ContractHrs,Quantity
PR06,5110006,2" XS,0.164,0.07215966
PR06,5110009,3" STD,58,30.74
PR06,5110017,6" STD,430.89,280.082
etc

I want to combine this two tables using query for reporting such that
Module1, Site CC1, Description1,ContractHrs1,Quantity1,Module2, Site CC2, Description2,ContractHrs2,Quantity2
PR06,5110000,1" XS CS,0,0,PR06,5110000,0,0,0
PR06,5110001,1" SCH 160 CS,0,0,PR06,5110001,0,0,0
PR06,5110002,1" XXS CS,0,0,PR06,5110002,0,0,0
PR06,5110003,1.5" XS CS,0,0,PR06,5110003,0,0,0
PR06,5110004,1.5" SCH1 60 CS,0,0,PR06,5110004,0,0,0
PR06,5110005,1.5" XXS CS,0,0,PR06,5110005,0,0,0
PR06,5110006,2" XS CS,0,0,PR06,5110006,2" XS,0.164,0.07215966
PR06,5110007,2" SCH 160 CS,7.656,17.4,PR06,5110007,0,0,0
PR06,5110008,2" XXS CS,0,0,PR06,5110008,0,0,0
PR06,5110009,3" STD CS,35.616,67.2,PR06,5110009,3" STD,58,30.74
PR06,5110010,3" SCH 80 CS,14.098,26.6,PR06,5110010,0,0,0

thanks for any help provided!!
Galantis.

 

[maxmangion]

Search this forum for "Union Query", this will allow you to combine your two sets of data.