Question

Which data manipulation command is used to combine the records from one or more tables?

Answer 1

Answer: JOIN

Explanation:

The SQL JOIN command is responsible for combining records from one or more tables. The JOIN command also locates related column values in the tables being joined.

There are four types of JOIN commands, namely -

1. INNER JOIN which selects the matching records from the tables

2. LEFT OUTER JOIN for selecting the records from the left table with matching records from the right table

3. RIGHT OUTER JOIN which is the opposite of the LEFTJOIN and helps select the records from the RIGHT TABLE which match to the records from the LEFT TABLE

4. FULL OUTER JOIN helps select the records that match with the records of either the right or the left table