復(fù)制代碼 代碼如下:

table a columns(key,value);
table b columns(key,value);

SELECT a.* FROM a LEFT JOIN b
ON a.key = b.key
WHERE b.key IS NULL