Types of joins in SQL

SQL join is an instruction to a database to combine data from more than one table. There are different kinds of joins, which have different rules for the results they create. In most SQL implementations you may find such joins as inner join, left join, right join, full join and also language implementation specific ones.

What is SQL?

SQL stands for Structured Query Language. Basically, SQL is used to communicate with and manipulate a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.