15-09-17, 11:48 AM
لدي هذا الاستعلام
كيف اجعل قيم null فى الاستعلام تتحول الي 0
كود :
SELECT dbo.ACCOUNT.Code AS [رقم الحساب], dbo.ACCOUNT.Name AS [اسم الحساب], SUM(dbo.DAY2.DEBIT) AS [مجموع المدين], SUM(dbo.DAY2.CREDIT) AS [مجموع الدائن],
SUM(dbo.DAY2.DEBIT - dbo.DAY2.CREDIT) AS الرصيد, dbo.ACCOUNT.GUID
FROM dbo.DAY1 INNER JOIN
dbo.DAY2 ON dbo.DAY1.GUID = dbo.DAY2.PAENT_GUID FULL OUTER JOIN
dbo.ACCOUNT ON dbo.DAY2.ACCOUNT_GUID = dbo.ACCOUNT.GUID
GROUP BY dbo.ACCOUNT.Code, dbo.ACCOUNT.Name, dbo.ACCOUNT.GUID