I have an SQL query combining two tables as below. In the results there are a lot of empty fields in Item_Total_Cost column which makes sense. However I would like these blank results to be replaced with a 0.
SELECT “Jobs”.“Job_Number”, “Query_Job_Item_Total_Cost”.“Item_Total_Cost” FROM “Jobs” LEFT OUTER JOIN “Query_Job_Item_Total_Cost” ON “Jobs”.“Job_Number” = “Query_Job_Item_Total_Cost”.“Job_Number”.
If I add the below line it splits out the fields I want to replace with 0, but I am not sure what to do from there?
WHERE “Query_Job_Item_Total_Cost”.“Item_Total_Cost” IS NULL