SELECT FROM tab_goods g LEFT JOIN tab_outbound o ON ggid=oo_gid LEFT JOIN tab_warehouse w ON oo_wid=wwid;SELECT FROM tab_goods g LEFT JOIN tab_storage s ON ggid=ss_gid LEFT JOIN tab_warehouse w ON s

可以使用UNION ALL将三个查询语句合并为一个查询语句：

SELECT * FROM tab_goods g LEFT JOIN tab_outbound o ON g.gid=o.o_gid LEFT JOIN tab_warehouse w ON o.o_wid=w.wid UNION ALL SELECT * FROM tab_goods g LEFT JOIN tab_storage s ON g.gid=s.s_gid LEFT JOIN tab_warehouse w ON s.s_wid=w.wid UNION ALL SELECT * FROM tab_goods g LEFT JOIN tab_deposit d ON g.gid=d.d_gid LEFT JOIN tab_warehouse w ON d.d_wid=w.wid;