数据类型不一致: 应为CHar, 但却获得 NUMBER
SELECT DISTINCT
A.REMARKS,
case when (select count(DOC_NO) from BULK_BUS_INVOICE_REFUSE where DOC_NO = A.RECINVOICE_NO) > 0 then '退回'
when (select count(DOC_NO) from BULK_BUS_INVOICE_REFUSE where DOC_NO = A.RECINVOICE_NO) <=0 then (select count(DOC_NO) from BULK_BUS_INVOICE_REFUSE where DOC_NO = A.RECINVOICE_NO) end
FROM BULK_BUS_RECINVOICE A
WHERE 1=1 ORDER BY A.RECINVOICE_NO DESC
sql语句是这个,为什么提示数据类型不一致, 应为CHar, 但却获得 NUMBER
我想判断 (select count(DOC_NO) from BULK_BUS_INVOICE_REFUSE where DOC_NO = A.RECINVOICE_NO) > 0
查询显示的时 (select count(DOC_NO) from BULK_BUS_INVOICE_REFUSE where DOC_NO = A.RECINVOICE_NO)的个数
为什么?