Left Vs Right Vs Full Join in SQL

A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.