728x90
반응형
A테이블에 있고, B테이블에 없는 데이터 조회 |
SELECT * FROM `collection_and_payment` A
LEFT OUTER JOIN `balhaengmul` B
ON A.uid=B.rUid
WHERE B.rUid IS NULL;
|
삭제하기 위해서는 임시테이블 사용 |
DELETE FROM `collection_and_payment` WHERE uid IN (SELECT * FROM
(SELECT A.uid
FROM `collection_and_payment` A
LEFT OUTER JOIN `balhaengmul` B
ON A.uid=B.rUid
WHERE B.rUid IS NULL) AS temp_table);
|
반응형
댓글