查询一张表中某字段不在另外一张表的记录

当查询A表中某字段不在B表中的记录时，采用下面的语句，效率比较高

select data_guid from (select data_guid from adam_entity_datas where table_name = 'GKGYHHW') minus select data_guid from gkgyhhwselect data_