MSSQL Select Problem

I am trying to select distinct rows from a mssql database view.

The query uses 4 tables to generate the data and I would like to select the distinct invoice numbers (INV No) to display on an HTML page (using PHP). I have tried adding the "DISTINCT" function but I can't seem to get it to work correctly.

Thanks for the help!

Here is the query for the view:

Code:


SELECT dbo.ARHEADER.[INVOICE NO] AS [INV No], dbo.ARHEADER.[INVOICE DATE] AS [INV Date], dbo.ARGLTRAN.[BATCH NO] AS [Bat. No],
dbo.ARGLTRAN.[BATCH YEAR] AS Year, dbo.ARGLTRAN.[BATCH PERIOD] AS Month, dbo.DEBTOR.NAMES AS [Customer Name],
dbo.ARGLTRAN.[DESC] AS [Details/Services], dbo.SALESREP.NAME AS [Sales Rep], dbo.DEBTOR.CSR, dbo.ARHEADER.[JOB NUMBER] AS [Job No],
dbo.ARGLTRAN.[SETUP CHARGE], dbo.ARGLTRAN.[MIN CHARGES], dbo.ARHEADER.FREIGHT, dbo.ARGLTRAN.[UNIT PRICE], dbo.ARHEADER.TOTQTY,
dbo.ARGLTRAN.[STANDARD RATE], dbo.ARHEADER.TOTDISC, dbo.ARHEADER.TOTTAX, dbo.ARHEADER.TOTNET, dbo.ARGLTRAN.[BATCH TYPE]
FROM dbo.ARHEADER INNER JOIN
dbo.ARGLTRAN ON dbo.ARHEADER.[INVOICE NO] = dbo.ARGLTRAN.[INVOICE NO] INNER JOIN
dbo.DEBTOR ON dbo.ARHEADER.[DEBTOR ACCT NO] = dbo.DEBTOR.[AC NO] INNER JOIN
dbo.SALESREP ON dbo.ARHEADER.[SALESREP RECNUM] = dbo.SALESREP.[DATAFLEX RECNUM ONE]
WHERE (dbo.ARGLTRAN.[BATCH TYPE] = 'DI')