JOIN TYPES

[sync-by-unito[bot]]

┆Issue is synchronized with this Trello card by Unito ┆Attachments: JOINS.pdf

[sync-by-unito[bot]]

➤ Canberk.Zor commented:

JOIN TYPES :

1-) INNER JOIN : The INNER JOIN keyword selects records that have matching values in both tables.

[sync-by-unito[bot]]

➤ Canberk.Zor commented:

JOIN TYPES :

‌

1-) INNER JOIN : The INNER JOIN keyword selects records that have matching values in both tables.

image.png ( https://trello.com/1/cards/6549f9845c4046b538140684/attachments/654a2a9077adbda506ac5063/download/image.png )

2-) LEFT OUTER JOIN : The LEFT JOIN keyword returns all records from the left table (table1), and the matching records from the right table (table2).

image.png ( https://trello.com/1/cards/6549f9845c4046b538140684/attachments/654a2aaa10c4d28a79f86966/download/image.png )

3-) RIGHT OUTER JOIN : The RIGHT JOIN keyword returns all records from the right table (table2), and the matching records from the left table (table1).

image.png ( https://trello.com/1/cards/6549f9845c4046b538140684/attachments/654a2b399ce5b9fd120cfde3/download/image.png )

4-) CROSS JOIN : The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also known as cartesian join.

image.png ( https://trello.com/1/cards/6549f9845c4046b538140684/attachments/654a2b550b16528c3faba777/download/image.png )

5-) UNION & UNION ALL :

The UNION operator is used to combine the result-set of two or more SELECT statements.

• Every SELECT statement within UNION must have the same number of columns
• The columns must also have similar data types
• The columns in every SELECT statement must also be in the same order.

image.png ( https://trello.com/1/cards/6549f9845c4046b538140684/attachments/654a2b6fd2a4f7cfafc2be17/download/image.png )

The UNION ALL command combines the result set of two or more SELECT statements (allows duplicate values).

image.png ( https://trello.com/1/cards/6549f9845c4046b538140684/attachments/654a2b90d6716a0b08f8a834/download/image.png )