Hi

Using MySql4.x

I have a table with

Email_address Member_Number List

Now for each email there is a number and a list, each email can be repeated for a different list but should have the same number ie:

John...@blueyonder.co.uk 1234 lista John...@blueyonder.co.uk 1234 listb John...@blueyonder.co.uk 5555 listc John...@blueyonder.co.uk 1234 listd

fr...@xx.com 3456 lista fr...@xx.com 3456 listb fr...@xx.com 3456 listc fr...@xx.com 3456 listd

Im trying to find out were an email has a different number associated

So in this example the result I would be after is:

John...@blueyonder.co.uk 1234 lista John...@blueyonder.co.uk 1234 listb John...@blueyonder.co.uk 5555 listc John...@blueyonder.co.uk 1234 listd

Help appreciated

Regards