左连接查询:
select * from goods g LEFT JOIN goods_common gc on g.goods_commonid=gc.goods_commonid where gc.goods_commonid is null;
左连接查询:
select * from goods g LEFT JOIN goods_common gc on g.goods_commonid=gc.goods_commonid where gc.goods_commonid is null;