Joins in SQL | SQL Bits | Kovolff
Channel: prelearn
Date: 2021-01-04

Joins allow you to connect two tables together
General code for joins
Type of Join TABLE_2_NAME
ON TABLE_1_NAME.FIELD_NAME = TABLE_2_NAME.FIELD_NAME

Join Types.
INNER JOIN: shows rows common to both tables
LEFT JOIN: shows all rows of table left of = sign
RIGHT JOIN: shows all rows of table right of = sign
OUTER JOIN: shows all rows of both tables

Formel 1 Data: https://ergast.com/mrd/db/#csv

#sql #joins #databases #learn