Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Limit # of recs on inner join?
- From: "Rodrigo E. De León Plicet" <rdeleonp(at)gmail(dot)com>
- To: Josh <josh(at)globalherald(dot)net>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Limit # of recs on inner join?
- Date: Mon, 31 Dec 2007 21:07:05 -0500
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 = ?
- References:
- Limit # of recs on inner join?
- From: Josh
- Limit # of recs on inner join?
- Prev by Date: Limit # of recs on inner join?
- Previous by thread: Limit # of recs on inner join?
- Indexes: