I need to select/exclude records from table1 where the id2 in table2 = 1.
How get the following results:
table 1
----
id
----
a
b
c
d
e
f
g
table 2
----
id / id2
----
b / 1
c / 1
d / 1
f / 1
c / 2
d / 2
a / 4
b / 4
need results
----
id
----
a
e
g
any suggestions?
thanksSELECT * FROM tblOne WHERE id_field IN (SELECT id_field FROM tblTwo WHERE other_id = 1)
No comments:
Post a Comment