Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
  • Table 1 Names
  • Table 2 Services

If I do a simple select of both tables together, I get a list as follows:

  • Name1 Service X
  • Name2 Service X
  • Name2 Service X
  • Name2 Service Y
  • Name3 Service Y
  • Name3 Service X

I would like to limit the list to only people who have Service X AND Y, one return per name (distinct select).

share|improve this question
Whoops, looks like my example table got squished. :( – access_victim May 7 '13 at 15:44
Thanks for the edit! Giving them a pivot table of the data in excel. I find it a lot more comfortable and friendly than Access. Bleh. SSRS reports make more sense to build than Access. I'll still need to build something more automatic if they plan on seeing this updated with any frequency. Might just directly update Excel from the Access connection and not poke around inside anymore. – access_victim May 7 '13 at 16:14
Please include the actual queries you are using. – terdon May 7 '13 at 16:28
And the tables' structures too. Thanks! – Mureinik Dec 14 '15 at 6:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.