Relacje w MySQL = LEFT JOIN … WHERE

SELECT <kolumny> FROM TabelaA A
    LEFT JOIN TabelaB B ON A.Key = B.Key
WHERE B.Key IS NULL