On Dec 31, 2007 1:52 PM, Josh <josh@globalherald.net> wrote:
> Instead, I just want:
>
> 1 A Cat In The Hat Dr. Seuss
SELECT books.book_id, books.title, (SELECT author_name FROM authors WHERE book_id = books.book_id
LIMIT 1) AS author_name
FROM books
WHERE books.book_id = ?