Postgres Pro
Downloads
Home   >   mailing lists

Re: Limit # of recs on inner join? - Mailing list pgsql-sql

From Rodrigo E. De León Plicet
Subject Re: Limit # of recs on inner join?
Date
Msg-id a55915760712311807l716a77e8l86873515f0ca1f9@mail.gmail.com
Whole thread Raw
In response to Limit # of recs on inner join?  (Josh <josh@globalherald.net>)
List pgsql-sql
Tree view 
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 = ?

pgsql-sql by date:

Previous
From: Josh
Date:
Subject: Limit # of recs on inner join?
Next
From: Richard Broersma Jr
Date:
Subject: Re: Limit # of recs on inner join?