Guest User

Untitled

a guest
Mar 9th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.21 KB | None | 0 0
  1. sqlite> SELECT bar.name, bar.foo, foo.id, foo.name FROM bar LEFT JOIN foo ON foo.id = bar.foo;
  2. thingy|1|1|bar
  3. sqlite> SELECT * FROM foo WHERE id = 1;
  4. 1|bar
  5. sqlite> SELECT * FROM bar WHERE foo = 1;
  6. sqlite>
Advertisement
Add Comment
Please, Sign In to add comment