The select orgid,
(select orgname from organize b where id=b.org id a.org orgname,
Count (*)
The from ${relatedownsmstable} a

Group by orgid
Union all
The select orgid, (select orgname from organize b where id=b.org id a.org orgname, count (*)
The from ${relatedownsmstable} a

Group by orgid
Union all
The select orgid, (select orgname from organize b where id=b.org id a.org orgname, count (*)
The from ${relatedownsmstable} a

Group by orgid
Union all
The select orgid, (select orgname from organize b where id=b.org id a.org orgname, count (*)
The from ${} a

Group by orgid


Would you please tell me why I write to the mistake? Online, such as the great god

CodePudding user response:

The select orgid, (select orgname from organize b where id=b.org id a.org orgname, count (*)
The from ${} a

CodePudding user response:

Placeholder inside, please don't mention the variable name? A great god

CodePudding user response:

refer to the second floor haodongqiang response:

placeholder inside, please don't mention the variable name? The great spirit

How do you didn't write a variable name (the name of the table)?