Forums

ASP

This topic is locked

joining recordsets

Posted 17 Oct 2002 09:24:06
1
has voted
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'>

Reply to this topic