need to take out duplicates 1

[ggreg]

how do I modify the sql below to do ascending order by title and remove duplicates so the titles will not duplicate for the fname and lname and take out the duplicates of name for fname and lname

select title, Fname, Lname, name
from books b, bookauthor ba, author a, publisher p
where b.pubID = p.pubid and b.isbn = ba.isbn
and ba.authorid = a.authorid
/
thanks

 

[carp]

select DISTINCT title, Fname, Lname, name
from books b, bookauthor ba, author a, publisher p
where b.pubID = p.pubid and b.isbn = ba.isbn
and ba.authorid = a.authorid
/

 

[ggreg]

wow that put it into ascending order but did not remove the duplicates should I be using group by but group by is giving me an error?

 

[ggreg]

carp I sorry i guess it is working and you did what i wanted it to do thanks!

 

[SantaMufasa]

Carp,

GGreg said he was grateful, and I believe him, so please have a purple star from me in his behalf.

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:56 (29Jul04) UTC (aka "GMT" and "Zulu"), 11:56 (29Jul04) Mountain Time)