我有以下三个表和结构:
id name education
1 test1 a
2 test2 b
3 test3 c
id name abcid
1 takr 1
2 test21 1
3 testlll 2
id name abcid
1 takr 2
2 test21 2
3 testlll 3
我想要所有基于abc表ID的数据
下面是查询
SELECT d.ID,l.VALUE_ID as RI_ID,l.UF_CRM_1486370412 as RI_AMT, f.VALUE_ID as Finance_Id , f.UF_CRM_1595053941 as FI_AMT
FROM b_uts_crm_lead as l
JOIN b_crm_deal as d
ON d.ID = l.UF_CRM_1600342528
JOIN b_uts_crm_financeaddition as f
ON d.ID = f.UF_CRM_1600350766
我猜你想要left join
:
select . . . -- the columns you want
from abc left join
xyz
on xyz.abcid = abc.id left join
pqr
on pqr.abcid = abc.id;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句