>Right! Thank you very much!
You are welcome.
Note that the idea of DISTINCT is that
the combination of all fields must be distinct; with GROUP BY, you specify for which field, or combination of fields, you want unique records.
Very useful, also, with sum(field), to get totals for each group.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
