>SELECT TABLEB.* FROM TABLEB LEFT OUTER JOIN TABLEA ; > ON TABLEB.PK = TABLEA.PK ; > WHERE TABLEB.PK != TABLEA.PK > >OR > >SELECT TABLEB.* FROM TABLEB LEFT OUTER JOIN TABLEA ; > ON TABLEB.PK = TABLEA.PK ; > WHERE TABLEA.PK = "" >