SELECT DISTINCT
O.Org _Id as orgId,
O.Org _Name as orgName,
A1. Add_Name AS xianqu,
A.A dd_Name AS pianqu,
O.Org _IsHandleLoan as orgIshandleloan,
S.S cope_Type as scopeType,
S.S cope_Object as scopeObject,
O.Org _IsIntelligent as orgIsintelligent
The FROM
Public_organization AS o
LEFT the JOIN loan_address AS a ON o.Org _Code=a.A dd_Code
LEFT the JOIN loan_address AS a1 ON a1. Add_Code=a.A dd_ParID
LEFT the JOIN cams_scope AS s ON o.Org _Id=s.Org _Id and spyware doctor el_Flag=0
WHERE
O.Org _ParentId IS NOT NULL
AND o.D el_Flag=0

CodePudding user response:

Table structure and index all have no

CodePudding user response:

CodePudding user response:

First post don't know what bosses need to send what things?

CodePudding user response:

To perform under this statement execution plan, see the index