I'm not sure wjat you want to do, but based on your comment:
Rceive pass--> soak fail--> repair Pass--> soak pass--> test pass--> dispatch
now i need to select only the products that follow the 1st process. if i select * from ListStage where passfail = 1 then it will return the value of the product which had a repair. and i want it to show only the products which do not have a repair
i recommend you to do something like this:
SELECT LS.*
FROM listStages AS LS LEFT JOIN Rceive AS RC ON LC.ProductID = RC.ProductID
WHERE RC.Pass=1
or
SELECT *
FROM listStages
WHERE ProductID IN (
SELECT ProductID
FROM Rceive
WHERE Pass=1)