above, subqueries, separate execution can query the result set, as the chart



SQL for

So the question to the

IN the face after 29 data query result set, total query result set is empty

But from the query result set inside any a number with=to perform data


Post for the first time, do not know to have described clearly, bosses to help explain the

CodePudding user response:

Firing a query written with as.
Or use left the join to see the result, know where is the problem

CodePudding user response:

Very laborious your code code, see several don't understand, you see behind in article 29 of the data come from
Can help here,

CodePudding user response:

You can double-click on copy the subquery found out the results to the UE, and see if it is due to the cause of the fill character

CodePudding user response:

refer to the second floor wmyyzzyq response:

very laborious your code code, see several don't understand, you see behind in article 29 of the data come from
Can help here,

Hard hard work, is the elder of SQL

CodePudding user response:

Preliminary suspect is a problem of char or varchar, ILINK and the corresponding field is varchar NO_DEL table?

CodePudding user response:

On the first floor, use left the join to view data, free estimate value