Sql子查询返回的值不止一个。当子查询跟随在 =、=、<<=、>>= 之后,或子查询用作表达式时,这种情况是不允许的

时间:2025-02-10 07:55:33

报错Sql语句:
SELECT WONO,
(select (select WLDesc FROM WL_Table where WLID=) as WLDesc where WOTaskArrange WONO=‘XXXXXX’
正确Sql语句:
SELECT WONO,
(select (select top 1 WLDesc FROM WL_Table where WLID=) as WLDesc where WOTaskArrange WONO=‘XXXXXX’

在子查询里添“top 1”