>Dear ALL,
>
>Help is highly appreciated...
>
>I need to select records from a table based on another table selection like so:
>
>TableA
>Selected1
>tID
>tValue
>
>TableB
>tID
>tCode
>
>IF tableA.selected1 > 0, select representing tableA.tID from table B, how can I do it by SQL statement?!
>
>SELECT * FROM TableB LEFT OUTER JOIN table A ON tableB.tID = TableA.tID WHERE tableA.selected1 > 0
>
>however, it only graps one record from tableB with corresponding record in table A... what's wrong?!
>
>Aaron
Hello Aaron,
Would this give you the desired result set?
SELECT TableB.*
FROM TableB
WHERE TableB.tID IN ( SELECT TableA.tID FROM TableA WHERE tableA.selected1 > 0 )
Mike