SELECT * FROM ORDER_GOODSINS WHERE ORDER_ID NOT IN (SELECT ORDER_ID FROM ORDER); --21.359s
SELECT * FROM ORDER_GOODSINS A WHERE NOT EXISTS (SELECT ORDER_ID FROM ORDER B WHERE A.ORDER_ID = B.ORDER_ID);--21.344
半连接算法
参考:
http://blog.sina.com.cn/s/blog_7c5a82970101ix2l.html