| bregent 2005-09-15, 4:16 am |
| In article <7f2We.487612$5V4.427016@pd7tw3no>, BT 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.
I already answered that for you when you posted it a few days ago. Just include
all of the fields in your select disctinct statement.
|