Select * from TABLE_A aa where Exists (Select ab.id From table_b ab And
ab.data_b = 100 And aa.id = ab.id)
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of peter_...@yahoo.com
Sent: Monday, December 16, 2013 12:41 PM
To:
I have two tables, TABLE_A and TABLE_B
TABLE_A:
--
ID: INT
DATA_A: INT
TABLE_A data:
(ID, DATA_A)
1, 11
2, 12
3, 13
4, 14
9, 19
TABLE_B:
--
ID: INT
DATA_B: INT
TABLE_B data:
(ID, DATA_B)
1, 100
2, 200
3, 200
5, 100
7, 300
9, 100
I want to do the following: get all records from