JOINS

  • A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them.
  • The JOIN operator allows you to combine multiple related tables to retrieve data based on the logical relationship between the tables.
  • There are five types of JOIN which are ANSI-compliant: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN and CROSS JOIN.
  • When tables involved in the JOIN operator contains same column name, it is required to qualify the column with the table name.




Subscribe to: Posts (Atom)