[求助]access NULL值替換為0

johnsztoo

ADO查詢:表3 left join 表1 ; 表3 left join 表1,注意:不能使用NZ() SELECT 表3.aaa, 表3.bbb, Sum(表3.ccc-表1.ccc+表2.ccc) AS ddd FROM (表3 LEFT JOIN 表1 ON (表3.aaa = 表1.aaa) AND (表3.bbb = 表1.bbb)) LEFT JOIN 表2 ON (表3.aaa = 表2.aaa) AND (表3.bbb=表2.bbb) GROUP BY 表3.aaa,表3.bbb; 如表1 aaa bbb ccc a1 b1 2 a2 b2 3 表2 aaa bbb ccc a3 b3 4 a4 b4 5 a1 b1 6 表3 aaa bbb ccc a1 b1 50 a2 b2 60 a3 b3 70 a4 b4 80 a5 b5 90 理想中的查詢結果: aaa bbb ccc a1 b1 54 a2 b2 57 a3 b3 74 a4 b4 85 a5 b5 90

ycyhjj2865

IIF（）函数

wwwwa

iif(isnull(f1),'',f1)