The 2 Most Common SQL Join Types: LEFT JOIN and INNER JOIN

Inner Join

INNER JOIN
Enter text here

Only the data where our search key is matched 

LEFT JOIN
Enter text here

All the data from the table in our FROM statment