Select Unique Records

I have a table that has a bunch of fields. One of the fields is title. There
is an author field as well as others. Two authors wrote one of the titles. I
want to have a record for both the authors with the same title. The problem
I want to be able to have a page that lists Only unique titles with other
fields for the record. When I use SELECT Distinct publications.TITLE from
publications I only get the Title field to display. Is there a way to select
Distinct title, but also to display all other fields for that record.

Thanks

In article <G%nVe.473285$5V4.354868@pd7tw3no>, NEWS says...

I have a table that has a bunch of fields. One of the fields is title. There
is an author field as well as others. Two authors wrote one of the titles. I
want to have a record for both the authors with the same title. The problem
I want to be able to have a page that lists Only unique titles with other
fields for the record. When I use SELECT Distinct publications.TITLE from
publications I only get the Title field to display. Is there a way to select
Distinct title, but also to display all other fields for that record.

Sure, just include all of the fields you want in your select statement.