Select之中的嵌套子查询报错This is not permitted when the subquery follows =, !=, <, <= , >

[m0_38012647]

SELECT
speorder.BIZ_DATE,
speorder.STORE_ID,
item.PROD_ID,
item.AMOUNT,
CASE
WHEN item.UNIT = (SELECT DICT_ITEM_ID FROM BASE_DICT_ITEM WHERE DICT_id ='prodUnit' AND ITEM_NAME='Unit') THEN
(
SELECT
(item.QTY / conversion.CONV_UNIT2_VAL) AS UQTY
FROM
SPE_MARSSFA_ORDER_ITEM item
LEFT JOIN MDM_UNIT_CONVERSION conversion ON item.PROD_ID = conversion.PROD_ID
WHERE
item.UNIT = (SELECT DICT_ITEM_ID FROM BASE_DICT_ITEM WHERE DICT_id = 'prodUnit' AND ITEM_NAME = 'Unit')
AND conversion.REMARK LIKE '1ACB=%'
)
ELSE
item.QTY
END AS QTY_ACB
FROM
dbo.SPE_MARSSFA_ORDER speorder
INNER JOIN SPE_MARSSFA_ORDER_ITEM item ON speorder.ID = item.MAIN_ID

[zbdzjx]

随便说说：把=换成in

[卖水果的net]

所涉及到的所有表的表结构都贴一下， create table 形式的。