Hi,

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 TABLE_A, for which ID exists in TABLE_B and DATA_B for that ID equals 100. Or in other words:
(1).from tableB, get all ID's for which DATA_B = 100 (here - 1,5,9), and then
(2).get all the records from TABLE_A containing an ID from(1)
In the above case, the desired result would be
1, 11
9, 19

Hope I explained it well.
Thanks for any suggestions.

Peter