You are very close. Just add a where clause: SELECT A.* FROM A LEFT OUTER JOIN B ON A.abc = B.abc WHERE B.abc IS NULL;.
確定! 回上一頁