Query Join?

[ledtear]

Given the two following tables:

TableA
id fld2
1 0
2 1
3 1
4 0

TableB
fld1 tableAId
AA 1
BB 2
CC 1
DD 3
EE 4
FF 2
GG 1
HH 3

I want to select from table B where the table A's fld2 == 1 so that my results in this case would be:

fld1
BB
DD
FF
HH

makes sense?

[Lars_Berg]

select tableB.fld1
  from tableB
  join tableA
    on tableB.tableAid = tableA.id
 where tableA.fld2 = 1