Skip to content

Instantly share code, notes, and snippets.

@zerothabhishek

zerothabhishek/explain-join-1.sql

Last active December 1, 2015 03:21
Show Gist options
  • Save zerothabhishek/2ad15c16de6f35d0a7a4 to your computer and use it in GitHub Desktop.
Save zerothabhishek/2ad15c16de6f35d0a7a4 to your computer and use it in GitHub Desktop.
Download ZIP
Sql left Join
Raw
explain-join-1.sql
SELECT posts.*, comments.*
FROM posts LEFT JOIN comments
ON posts.id = comments.post_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment