SELECT * FROM ( SELECT * FROM A WHERE A.something = 1 ) AA, ( SELECT * FROM B WHERE B.something = 2) BB WHERE AA.bob = BB.bob