# Learn SQL: Left Join ![rw-book-cover](https://api.boot.dev/v1/static/course_image/learn-sql) ## Metadata - Author: [[boot.dev]] - Full Title: Learn SQL: Left Join - Category: #articles - Summary: The text shows how to create a users table in SQL with different columns. It inserts multiple user records with details like name, age, and username. The focus is on practicing SQL commands, especially the LEFT JOIN concept. - URL: https://www.boot.dev/lessons/1386caad-9db7-4a59-91c7-2dd5fd6cb204 ## Highlights - A `LEFT JOIN` will return every record from `table_a` regardless of whether or not any of those records have a match in `table_b`. A left join will *also* return any matching records from `table_b`. ([View Highlight](https://read.readwise.io/read/01keg9qheq1zcfpaxzr3a4wxpw))