提示这样是因为在条件里嵌套了子查询语句,最好用“in”语句
如下面
select OrgName from Type where Pid = (select Did from Type where OrgName='" + Parent + "')
要改为:
select OrgName from Type where Pid in (select Did from Type where OrgName='" + Parent + "')
才行
提示这样是因为在条件里嵌套了子查询语句,最好用“in”语句
如下面
select OrgName from Type where Pid = (select Did from Type where OrgName='" + Parent + "')
要改为:
select OrgName from Type where Pid in (select Did from Type where OrgName='" + Parent + "')
才行