在获取数据时，我在联接中遇到问题

Question

我有三张桌子和结构如下：

1. abc

     id name    education
     1  test1   a
     2  test2   b
     3  test3   c

1. pqr

    id  name    abcid
    1   takr    1
    2   test21  1
    3   testlll 2

1. xyz

    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

Answer 1

我猜你想要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;