LEFT OUTER JOIN – Join Multiple Tables in SQL
LEFT OUTER JOIN is a type of OUTER JOIN which fetches you all the rows from the LEFT table and matching rows from the RIGHT table based on the provided ON condition.
LEFT OUTER JOIN is a type of OUTER JOIN which fetches you all the rows from the LEFT table and matching rows from the RIGHT table based on the provided ON condition.
In SQL Cross Join, the result is a Cartesian product of the 2 tables (or more, if specified). This means that each row from first table is associated with each row from second table.
SQL SELF JOIN- This type of join is used when a table needs to be compared with itself.
RIGHT OUTER JOIN is also a type of OUTER JOIN which fetches you data from multiple tables but this time it fetches all the data from RIGHT table and only matching data from the LEFT table.
SQL Inner Join logically connects 2 or more tables on the given condition and fetches you only the matching records from both the tables.
JOIN is an SQL clause which is used to connect 2 or more table based on some common column and fetching data from them.