Re: [SQL] Limit # of recs on inner join?

[Rodrigo E. De León Plicet]

On Dec 31, 2007 1:52 PM, Josh <[EMAIL PROTECTED]> 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 = ?

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org