SELECT DISTINCT
o.Org_Id as orgId,
o.Org_Name as orgName,
a1.Add_Name AS xianqu,
a.Add_Name AS pianqu,
o.Org_IsHandleLoan as orgIshandleloan,
s.Scope_Type as scopeType,
s.Scope_Object as scopeObject,
o.Org_IsIntelligent as orgIsintelligent
FROM
public_organization AS o
LEFT JOIN loan_address AS a ON o.Org_Code = a.Add_Code
LEFT JOIN loan_address AS a1 ON a1.Add_Code = a.Add_ParID
LEFT JOIN cams_scope AS s ON o.Org_Id = s.Org_Id and s.Del_Flag = 0
WHERE
o.Org_ParentId IS NOT NULL
AND o.Del_Flag = 0
uj5u.com熱心網友回復：
表結構和索引都沒有 怎么看uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
第一次發帖不知道要發啥東西 大佬們還需要什么嗎？uj5u.com熱心網友回復：
對這個陳述句執行下執行計劃，看看走了索引沒轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/268877.html
標籤：Java相關