Hello all,

I need your help please.

In table1 there are 2 fields: field1 & field2.
I am trying to check field1 for duplicate. If duplicates are found, I want to make sure field2 are the same. If field2 are different, generate a report.

How can I do this using SQL statement?

Returned Records should look like:
field1, field2
000001, ssssss
000001, sssss1
00dddd, 12kkkk
00dddd, 12hhhh

These 2 fields are string and no primary key are set.

Thank you so much.