表A---------------------------------关联第一张表B-----------------------关联第二张表c select * fomr 表名A left join 表B on 表A字段=表B的id left join 表c on 表B字段=表c的id 或者从中间表 B 开始 leftjoin A on b.ID =A.ID left join on b.id = c.id
select * from eb_order_form f left join prp_main p on f.ebusiness_no = p.ebusiness_no left join eb_cmsn_get e on f.ebusiness_no = e.ebusiness_no;