Answer»
There are various types of join statements you can use depending on the use case you have. Specifically, there are four types of joins as follows:
Inner Join: This method returns datasets that have the same values in both tables.
Full Join: This is also referred to as a full outer join. It combines all rows from the left table and the right table to create the result set. It means that a query would return records from both tables, even if they had NULL values. If there are no matching rows, the result-set (joined table) will display NULL values.
Right Join: This is also referred to as the Right outer join. All records from the right table will be returned, as well as any records that match from the left table.
Left Join: This is also referred to as Left outer join. All records from the left table will be returned, as well as any records that match from the right table.
|
