Limit # of recs on inner join?

Поиск
Список
Период
Сортировка
От Josh
Тема Limit # of recs on inner join?
Дата
Msg-id alpine.LRH.1.00.0712311347330.31526@home-av-server.home-av
обсуждение исходный текст
Ответы Re: Limit # of recs on inner join?
Re: Limit # of recs on inner join?
Список 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 по дате отправления:

Предыдущее
От: Trilok Kumar
Дата:
Сообщение: Re: sql query question ?
Следующее
От: "Rodrigo E. De León Plicet"
Дата:
Сообщение: Re: Limit # of recs on inner join?