Problem Creating View With DISTINCT Column

Hi Guys

I'm trying to create a view in SQL Server to display only one copy of all records in a table, where some of the records are exact matches to other records (except for an ID autoincrement field)

I have the following code that displays distinct titles:

sql Code:






Original
- sql Code




SELECT DISTINCT DocTitle
FROM dbo.TBL_TABLE_NAME






SELECT DISTINCT DocTitleFROM         dbo.TBL_TABLE_NAME



But when i use this code (adding one field to query), it displays all the duplicate records also, which I do not want:

sql Code:






Original
- sql Code




SELECT DISTINCT DocTitle, ID
FROM dbo.TBL_TABLE_NAME






SELECT DISTINCT DocTitle, IDFROM         dbo.TBL_TABLE_NAME




I want to get the distinct results for DocTitle, with 5 other columns added to the query so they can be displayed in a web page list.
The query I want is something like this, but I can not get it to work:

sql Code:






Original
- sql Code




SELECT DISTINCT DocTitle, ID, FirstName, LastName, Company, DocDescription, DocFile
FROM dbo.TBL_TABLE_NAME
ORDER BY DocTitle






SELECT DISTINCT DocTitle, ID, FirstName, LastName, Company, DocDescription, DocFileFROM         dbo.TBL_TABLE_NAMEORDER BY DocTitle



I know this query works from an MS Access DB, but I need it to work from SQL Server.

I am using SQL Server 2000

Any help is greatly appreciated.

Alex