Troy,
Sorry for the late reply, but you can use this:
select
b.bid,
b.isbn,
b.title,
a.aid,
a.firstname,
a.lastname
from
book b,
author_book ab,
author a
where
b.bid = ab.bid
and
ab.aid = a.aid
and ab.aid = (
select min(aid)
from author_book ab2
where ab2.bid = ab.bid)
This
-
From: Troy Simpson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 4:08 PM
To: CF-Talk
Subject: Weird Join (o8i)
Problem: I perform a Join and I get two records for a book with two
authors. I do not really want two records. I would like to have one
record for the book
Problem: I perform a Join and I get two records for a book with two
authors. I do not really want two records. I would like to have one
record for the book with both(or more) authors on the same row.
Anyone run into something like this before? If so, how did you resolve
it?
Here is more
Subject: Weird Join (o8i)
Problem: I perform a Join and I get two records for a book with two
authors. I do not really want two records. I would like to have one
record for the book with both(or more) authors on the same row.
Anyone run into something like this before? If so, how did you resolve
4 matches
Mail list logo