Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 951F72E00C0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 31 Dec 2007 22:07:09 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 77588-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 31 Dec 2007 22:07:06 -0400 (AST)
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.245])
	by postgresql.org (Postfix) with ESMTP id C736D2E006F
	for <pgsql-sql@postgresql.org>; Mon, 31 Dec 2007 22:07:06 -0400 (AST)
Received: by an-out-0708.google.com with SMTP id c36so919429ana.33
	for <pgsql-sql@postgresql.org>; Mon, 31 Dec 2007 18:07:05 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	bh=2xWfmzLmd3M+NH3trheRDc6fqX8TRzeT/KmsfbGRpdE=;
	b=uk4mmmRova5k9r5uD650mIyFYLlgsPKBINNUbG8IzD7wtgUH4pbnH+jPODgz4lSZOc1O+11cQuwOOudSKJGQkDpYomZJewGc0iT+JVt1qwcOUB4Uqbk/JXUSnfJCQg8Ke2pIwSXFaCn6famngaGcAWYVyDjkPa7TpvTFC/4cyPc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=kes8+I4UiWGE0IcEsQFXOsOKPZ6PLDNMpcQPsVDSwK/FNLR4824457ks/U6YzhGU21H12sAdq0ZOGIGz9+uI58cSCYAcZoCzgarJzVZdR8HZRfCLbSmaF1TQKCNvwF3EZ0ZLagEmh58+fFvswOEHqWnWYvP+6v54ow+/e4jb3JA=
Received: by 10.100.135.16 with SMTP id i16mr27053200and.51.1199153225645;
	Mon, 31 Dec 2007 18:07:05 -0800 (PST)
Received: by 10.100.34.6 with HTTP; Mon, 31 Dec 2007 18:07:05 -0800 (PST)
Message-ID: <a55915760712311807l716a77e8l86873515f0ca1f9@mail.gmail.com>
Date: Mon, 31 Dec 2007 21:07:05 -0500
From: "=?UTF-8?Q?Rodrigo_E._De_Le=C3=B3n_Plicet?=" <rdeleonp@gmail.com>
To: Josh <josh@globalherald.net>
Subject: Re: Limit # of recs on inner join?
Cc: pgsql-sql@postgresql.org
In-Reply-To: <alpine.LRH.1.00.0712311347330.31526@home-av-server.home-av>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <alpine.LRH.1.00.0712311347330.31526@home-av-server.home-av>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/162
X-Sequence-Number: 29854

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 = ?