sql多表查询

SELECT * FROM  good_item WHERE  id IN (          SELECT  good_item_id FROM order_item WHERE order_id IN (SELECT          order_id FROM  share_order)) AND member_id is NOT NULL  \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\          SELECT id,oeder_id,pv,create_time FROM share_order a ,order_item b , good_item c          where a.order_id=b.order_id          and b.good_item_id=c.id and good_item.code=?