SQL – Full Join Table of content The SQL Full Join SQL Full Join creates a new table by joining two tables as a whole. The joined table contains all records from both the tables and fills NULL values for missing matches on either side. In short, full join is a type of outer join […]
Category Archives: sql
SQL – DELETE JOIN Table of content Simple deletion operation in SQL can be performed on a single record or multiple records of a table. And to delete records from multiple tables, the most straightforward approach would be to delete records from one table at a time. However, SQL makes it easier by allowing the […]
SQL – Self Join Table of content Self Join, as its name suggests, is a type of join that combines the records of a table with itself. Suppose an organization, while organizing a Christmas party, is choosing a Secret Santa among its employees based on some colors. It is designed to be done by assigning […]