Error with SQL Statement

[techmanbd]

Ok Here is my SQL Statement

 

 

 

SELECT TblPFtestData.TestID, TblPFtestData.AssyRev, TblPFtestData.SalesRev, (Select tblPassFail.PassFail FROM tblPassFail INNER JOIN tblPFtestdata ON tblPassFail.PFID = tblPFtestdata.PFcurrentL) AS CurrentL,

(Select tblPassFail.PassFail FROM tblPassFail INNER JOIN tblPFtestdata ON tblPassFail.PFID = tblPFtestdata.PFcurrentNL) AS CurrentNL

 

FROM TblPFtestData

 

Ok when I run it, it works fine if only 1 record is in tblPFtestdata

 

if I add another record I get this error

 

"At most only one record can be returned by this subquery"

 

I don't see why it would say this

Here is what I am doing. I have one table tblPASSFAIL. with a column PFID of 1 or 2 and also has column PASSFAIL with "PASS" or "FAIL" corresponding

 

I have another table which has about 7 columns which will show a 1 or 2 and I want to make a query that puts where the 1 or 2, Make it "PASS" or "FAIL"

 

thanks for any help

[techmanbd]

found my own problem, intead of using INNER JOIN, I just use

Select .... from ....... where