Dear All,
Can someone help me find the correct syntax of a SQL statement would eliminate the duplicates?
I have a table: 'mytable'. It has 3 fields: ID, NAME and REF
ID | NAME | REF
1 | Dupuis | 200817 *
2 | Durand | 200817
3 | Michiels | 200818 *
4 | Dulome | 200819
5 | Pernut | 200820 *
6 | Bloquier | 200820
7 | Moureau | 200820
8 | Pirotte | 200821 *
9 | Marchand | 200821
I would like the SQL statement to return only the records that are tagged (all fields).
How can I do this?
Thanks to all,
Pat