Actually I was able to knock out something last evening:

Select A.* from ExteriorWallCodes A INNER JOIN

(Select min(intID) as intID,vchrCode from ExteriorWallCodes

Group by vchrCode) B

ON (a.intID=b.intID and A.vchrCode = B.vchrCode)

order by A.intID

Thanks for the help though... I just need to look at both because from a table of 41 items, yours returns 29 and mine returns 27, just need to see whats what and why 🙂

regards,

Chris