Why would this query return duplicate reportnumber records when I am using the distinct reportnumber in the select statement?
SELECT DISTINCT reportnumber, lpatname + ',' + fpatname AS patname,reportdate,hideview,reportid,physicianid,ssn,signdate,locked,mdedit,transedit FROM reports
WHERE origuserid = 9
ORDER BY reportdate desc
Thanks..............
Chris Scott
The Whole Computer Medical Systems
SELECT DISTINCT reportnumber, lpatname + ',' + fpatname AS patname,reportdate,hideview,reportid,physicianid,ssn,signdate,locked,mdedit,transedit FROM reports
WHERE origuserid = 9
ORDER BY reportdate desc
Thanks..............
Chris Scott
The Whole Computer Medical Systems