On Dec 31, 2007 1:52 PM, Josh <josh(at)globalherald(dot)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 = ?