Posted by paulmac106 on 03/07/07 16:59

I think it's simple, but I can't get it to work.

In English its: find records in TableA where the field [Field1] has
more than one unique value in Field2

sample records in TableA

Field1 Field2
2241 12345
2241 12345
2242 12345
2242 99856

desired return (2 records)
2242 12345
2242 99856

thank you for your help

Paul

• Next in forum: get value of last item in column?
• Prev in forum: Re: insert into linked server problem
• Thread view: Simple SQL Help

[Reply to this message]