# LEFT JOIN ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course#5.3 Google Analytics - 5 Analyze - Module 3 - Aggregate Data for Analysis Aggregate Data for Analysis|Google Analytics Certificate]] #### Sub-context: [[JOIN]] >[! Definition] >A SQL function that will return all the records from the left table and only the matching records from the right table ## Examples ```SQL SELECT * FROM movies.titles LEFT JOIN movies.actors ON movies.titles.id = movies.actor.movie_id ``` ## Related ## Resources ![[understanding joins.png]] ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) A SQL function that will return all the records from the left table and only the matching records from the right table @@@ [[LEFT JOIN]]