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

Outlook 2010 has an "SQL mode" for filters, that allow the user to type a WHERE clause that is used to select the mail shown in the view/folder. In my quest to create a gmail work-a-like view, I would like to filter all messages that are part of a conversation that contains at least one not archived (indicated by a category) message.

Now, of this were real SQL you would do this with a subselect or a join to iterate over all the messages in the source message's conversation. Do we have a similar option using an SQL filter?

share|improve this question

This is not a real SQL. This is a SQL DASL. It does not support subqueries.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.