G
Guest
my query gives me results like this:
6 Joe Bloggs n.a.
6 Joe Bloggs n.a.
6 Joe Bloggs n.a.
6 Joe Bloggs n.a.
14 Fred Smith 123
14 Fred Smith 123
14 Fred Smith 123
14 Fred Smith 123
I only want to pick one result for each person.
I thought that could be accomplished by using a SELECT and GROUP BY
instruction but I cannot get it to work.
Any ideas pls?
Thanks
6 Joe Bloggs n.a.
6 Joe Bloggs n.a.
6 Joe Bloggs n.a.
6 Joe Bloggs n.a.
14 Fred Smith 123
14 Fred Smith 123
14 Fred Smith 123
14 Fred Smith 123
I only want to pick one result for each person.
I thought that could be accomplished by using a SELECT and GROUP BY
instruction but I cannot get it to work.
Any ideas pls?
Thanks