From: Rodrigo E. De León Plicet <rdeleonp@gmail.com>
To: Josh <josh@globalherald.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Limit # of recs on inner join?
Date: Mon, 31 Dec 2007 21:07:05 -0500
Message-ID: <a55915760712311807l716a77e8l86873515f0ca1f9@mail.gmail.com> (raw)
In-Reply-To: <alpine.LRH.1.00.0712311347330.31526@home-av-server.home-av>
References: <alpine.LRH.1.00.0712311347330.31526@home-av-server.home-av>
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 = ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rdeleonp@gmail.com, josh@globalherald.net
Subject: Re: Limit # of recs on inner join?
In-Reply-To: <a55915760712311807l716a77e8l86873515f0ca1f9@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox