Don't Understand CCM Query Wizard

Although i'm quite familiar with querying a database, for the life of me, i can't figure out the query wizard in CCM. I am trying to build a simple query (A or B or C) AND (D). I can't seem to figure out how to do this using the Add and Or Groups in the CCM query builder.
Any help would be appreciated
Accepted answer

Hi Joe,
Not sure if this gives the output you are looking for...
1. In Eclipse, create a new query (from scratch). Note: The default condition in the main window == AND.
2. Click on the 'Condition' dropdown on the top right of the window and select "OR group". This will create a sub OR group within the main group
3. In the main Group, add condition D in your example
4. In the sub OR group, add conditions A, B and C
Not sure if this gives the output you are looking for...
1. In Eclipse, create a new query (from scratch). Note: The default condition in the main window == AND.
2. Click on the 'Condition' dropdown on the top right of the window and select "OR group". This will create a sub OR group within the main group
3. In the main Group, add condition D in your example
4. In the sub OR group, add conditions A, B and C