mysql inner join与 left jion 连用

SELECT
a.uuid,
a.pay_id,
b.core_enterprise_name,
a.financial_institutions_id,
c.financial_institutions_name,
d.sign_body_name,
a.periods,
e.suppliers_name,
a.suppliers_account,
a.open_account_bank,
a.account_name,
a.suppliers_rate_biz,
f.item_company_name,
a.loan_date,
a.account_receivable,
a.due_date,
a.suppliers_money,
a.contract_type,
a.pay_priority,
a.item_name,
a.transfer_apply_date,
g.region_name,
h.contract_name,
a.base_contract_name,
a.base_contract_no,
l.large_region_name,
b1.supplement_status
FROM
biz_pay_comfirm_info a LEFT JOIN biz_supplement_account b1 on a.pay_id = b1.pay_id and b1.sys_status = 1,
biz_core_enterprise b,
biz_financial_institutions c,
biz_signing_body d,
biz_suppliers e,
biz_item_company f,
biz_contract_info h,
biz_item_region g
LEFT JOIN biz_large_region_mapping k ON g.uuid = k.item_region_uuid
AND k.sys_status = 1
LEFT JOIN biz_large_region l ON k.large_region_uuid = l.uuid
AND l.sys_status = 1
WHERE
a.core_enterprise_id = b.uuid
AND a.financial_institutions_id = c.uuid
AND a.signing_body_id = d.uuid
AND a.suppliers_id = e.uuid
AND a.item_company_id = f.uuid
AND f.region_id = g.uuid
AND a.contract_id = h.uuid
AND a.sys_status = 1
AND b.sys_status = 1
AND c.sys_status = 1
AND d.sys_status = 1
AND f.sys_status = 1
AND g.sys_status = 1
AND h.sys_status = 1
and a.financial_institutions_id = ‘f1022’
and a.periods = ‘1’

转自：https://www.cnblogs.com/xiaoniuniu886/p/10944564.html