一对多关系中，查没儿子的记录语句

SELECT B.* 
FROM tbl_mall_order B
WHERE NOT EXISTS
     (SELECT 'X' FROM tbl_mall_shoping_log C
      WHERE C.order_no = B.order_no)