G
Guest
I have a table called table1 with two field
Field1 called user_name
Field2 called machine_name
I want to delete any duplication
so if my table is
user_name machine_name
aa 1
aa 2
bb 1
bb 1
bb 1
cc 1
cc 2
cc 1
cc 2
cc 3
I want to be left with
user_name machine_name
aa 1
aa 2
bb 1
cc 1
cc 2
Can you help thanks
Field1 called user_name
Field2 called machine_name
I want to delete any duplication
so if my table is
user_name machine_name
aa 1
aa 2
bb 1
bb 1
bb 1
cc 1
cc 2
cc 1
cc 2
cc 3
I want to be left with
user_name machine_name
aa 1
aa 2
bb 1
cc 1
cc 2
Can you help thanks