SELECT (CASE
(SELECT SUM(PROPEICE)
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id) WHEN NULL THEN '0' END) AS smoney
FROM DB_USER这样写出来 smoney 显示还是空,我在上面已经让他为null的时候设为0了,不知道为什么不顶用
(SELECT SUM(PROPEICE)
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id) WHEN NULL THEN '0' END) AS smoney
FROM DB_USER这样写出来 smoney 显示还是空,我在上面已经让他为null的时候设为0了,不知道为什么不顶用
(SELECT SUM(PROPEICE)
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id)
IS null THEN '0' else '0' END) AS smoney
FROM DB_USER
(SELECT SUM(PROPEICE)
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id) WHEN NULL THEN '0' else '0' END) AS smoney
FROM DB_USER 这样试下
(SELECT SUM(PROPEICE)
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id)
IS null THEN '0' else SUM(PROPEICE) END) AS smoney
FROM DB_USER
SELECT (isnull(SELECT SUM(PROPEICE)
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id),0) AS smoney
FROM DB_USER
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id) AS smoney
FROM DB_USER
SELECT (SELECT SUM(isnull(PROPEICE,0))
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id) AS smoney
FROM DB_USER
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id) AS smoney
FROM DB_USER
这样就对了。
FROM DB_PRODUCT_ORDER
WHERE userid = DB_USER.id) AS smoney
FROM DB_USER
sum必须放到里边才行谢了,兄弟们