Thanks!

Thank you so much. Both of your solutions worked perfectly! I appreciate your help on this. I can see I need to spend a lot more time on derived Tables and Joins...

I have 2 tables:
Users --> email, UID (pk)
Orders --> Ordernumber, UID (pk)

I am trying to clean up the database. Some users have created multiple accounts in the database. Each account they create will generate a new UID but will have their same email address. I need to find which email addresses have multiple UIDs and which of those UIDs have an Ordernumber associated with it (for example, an account could have been...