Forums
This topic is locked
joining recordsets
17 Oct 2002 09:24:06 cady posted:
<font face='Tahoma'>how can i join 2 recordsets so that it returns results that are not completly filterd? i know that doesn't make much sense( as you can tell i'm not an SQL guru!) but i don't know how else to put it. here's the code though...Recordset 1:
SELECT *
FROM tblJob j, tblStage s, tblCustomer c
WHERE j.strStatusCode = s.strStatusCode
AND j.CustomerID =c.CustomerID
AND s.strStatusCode ='3'
Recordset 2:
SELECT *
FROM tblJob j , tblVendorJobSupp v
WHERE j.nbrJobNo = v.nbrJobNo AND v.strStatusCode = '3'
now i want to bring these 2 together because i need to write a report based on the data of these tables. they are all tied by the nbrJobNo field and i want to filter it based on the strStatusCode.
the problem is that when i try to bring it together into one query i get inaccurate results. i need to have it in one query so that i can repeat the results down the page.
any ideas or am i asking something out of left field?
appreciate any info you can supply.
thanks</font id='Tahoma'>