in reply to Re^2: perl dbi select questionin thread perl dbi select question
ok, so you need a full join:
SELECT DISTINCT tableA.x FROM tableA,tableB WHERE tableA.y=tableB.z