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

From Josh
Subject Limit # of recs on inner join?
Date
Msg-id alpine.LRH.1.00.0712311347330.31526@home-av-server.home-av
Whole thread Raw
Responses Re: Limit # of recs on inner join?
Re: Limit # of recs on inner join?
List pgsql-sql
I want to limit the number of records returned by an inner join.

Suppose I have a table of Books:

book_id
title

And, a table of authors:

book_id
author_name

Now, suppose I want to get book + author, but I only want one author for 
books with multiple authors.  Traditionally, I'd do something like:

select books.book_id, books.title, authors.author_name
from books
inner join authors on authors.book_id = books.book_id
where books.book_id = ?

This might return:

1    A Cat In The Hat    Dr. Seuss
1    A Cat In The Hat    Dr. Seuss' Partner

Instead, I just want:

1    A Cat In The Hat    Dr. Seuss

How can I limit the inner join?

Cheers,
-J



pgsql-sql by date:

Previous
From: Trilok Kumar
Date:
Subject: Re: sql query question ?
Next
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: Limit # of recs on inner join?