select aaaaaa.field1, aaaaaa.field2, bbbbbb.fieldfrombbbbbb ; from table1 aaaaaa ; inner join table2 bbbbbb on bbbbbb.somefield=aaaaaa.somefield; where aaaaaa.field1="X"