sql joins

ASQL Join is an instruction to combine data from two sets of data (tables).

SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key; it specifies that the database management system is organized in such a way that there are clear relations defined between different sets of data. (sql jons description courtesy of  sql-joins)

Different Types of SQL JOINs:



  • (INNER) JOIN: Returns records that have matching values in both tables
  • LEFT (OUTER) JOIN: Return all records from the left table, and the matched records from the right table
  • RIGHT (OUTER) JOIN: Return all records from the right table, and the matched records from the left table
  • FULL (OUTER) JOIN: Return all records when there is a match in either left or right table

image courtesy of  imgur

Comments

Popular posts from this blog

Spain's nuclear legacy