Skip to content

Instantly share code, notes, and snippets.

@zmsmith

zmsmith/gist:540391

Created August 20, 2010 14:09
Show Gist options
  • Save zmsmith/540391 to your computer and use it in GitHub Desktop.
Save zmsmith/540391 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT `author`.`id`, `author`.`first_name`, `author`.`last_name`
FROM `author`
INNER JOIN `author_books`
ON (`author`.`id` = `author_books`.`author_id`)
WHERE `author_books`.`book_id`
IN (SELECT U0.`book_id` FROM `bookstore_books` U0 WHERE U0.`bookstore_id` = 1 )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment