1/* deffrent ways to replace null in
2isnull() function
3case statement
4coalecse() function*/
5SELECT Aliase_Name.Column_Name AS IS NULL(Aliase_Name.Column_Name, "Message") AS Column_Name
6FROM Left_Table_Name Aliase _Name
7JOIN_TYPE Right_Table _Name Aliase_Name
8ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name
9
10/*............*/
11SELECT Aliase_Name.Column_Name AS Aliase_Name
12 CASE
13 WHEN ALiase_Name IS NULL THEN "Message" ELSE ALiase_Name.Column_Name
14 END
15 AS Aliase_Name
16FROM Left_Table_Name Aliase _Name
17JOIN_TYPE Right_Table _Name Aliase_Name
18ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name
19
20/*...........*/
21SELECT Aliase_Name.Column_Name AS COALESCE (Aliase_Name.Column_Name, "Message") AS Column_Name
22FROM Left_Table_Name Aliase _Name
23JOIN_TYPE Right_Table _Name Aliase_Name
24ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name
25