SQL:
  1. SELECT A.UserId
  2. FROM
  3. (
  4.       SELECT UserId FROM Users WHERE Email LIKE '%.com'
  5. ) A,
  6. (
  7.       SELECT UserId FROM Users WHERE Email LIKE '%er%'
  8. ) B
  9. WHERE A.UserId = B.UserId

Result A:

10059
10060
10061
10062
10063
10082
10058
10088
10089

Result B:

10059
10063
10087
10089

Result query:

10059
10063
10089

If there are other ways to acomplish this, please let me know.

Lieven Cardoen aka Johlero