SELECT UID, name, address
FROM SCM_office
WHERE UID
NOT IN (SELECT OID FROM SCM_match)
mysql 버전때문에 서브퀘리가 안되면 어떻게 해야 되나요?
LEFT JOIN SCM_match ON SCM_office.UID = SCM_match.OID
WHERE SCM_match.OID IS NULL
;