You don't want OUTER JOIN in this acse. Try
SELECT TableB.* ;
FROM TableB JOIN tableA ON TableB.tID = TableA.tID ;
WHERE tableA.selected1 > 0
>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?!
>
--sb--