If one has a long SELECT statement with a number of fields in it, does the use of "DISTINCT" at the outset make it the functional equivalent of DISTINCTROW?  If so, how does one use DISTINCT when there is a long select clause.  In my situation, I have a query that makes a"FullName" and it is at the first of the SELECT clause which also has address information lots of other stuff.  I only want DISTINCT to apply to FullName.  I tried and it doesn't.  How should I fix it?  I note the SELECT clauses in the video all just contain one field.

---

Reply from Alex Hedley:

You need to have only the Field you wish to be DISTINCT in the Query, unless you use a subquery.