SQL FULL JOIN
The SQL FULL JOIN is the result of combination of both left and right join tables with all the records from both tables.It replaces NULL on the place of matches not found. Syntax SELECT table1.column1, table2.column2... FROM table1 FULL JOIN table2 ON table1.commonfield = table2.commonfield; Example let look at the following two tables Table 1 – Students ID Name Address Gender 1 Krishna…
View On WordPress











