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