Replace NULL values in SQL
SELECT d . DepartmentID , Name , Budget , StartDate , Title , Credits FROM Department d left join Course c on c . DepartmentID = d . DepartmentID DepartmentID Name Budget StartDate Title Credits 1 Engineering 350000.00 2007-09-01 00:00:00.000 EEE 8 1 Engineering 350000.00 2007-09-01 00:00:00.000 ECE 7 1 Engineering 350000.00 2007-09-01 00:00:00.000 Civil 5 1 Engineering 350000.00 2007-09-01 00:00:00.000 CSE 6 1 Engineering 350000.00 2007-09-01 00:00:00.000 Mech 6 1 Engineering 350000.00 2007-09-01 00:00:00.000 IT 4