SELECT table1.* FROM Table1 ; > INNER JOIN Table2 ON table2.fk = table1.pk and Table2.Somefield = xSomeValueI only replied to stress that JOINS cannot replace EXISTS in all cases. Your query is definately different from±
SELECT * FROM Table A ; WHERE EXISTS (SELECT * FROM Table2 B WHERE a.Pk = b.fk AND SomeField = xSomeValue)Where both can return different results depending on the data.