Question on Query Wizard

rbuser

Hi All,

I am using D5, and RB Enterprise v6.03. I have a user trying to create a
report and we cannot seem to get the correct results without editing the
sql, or using code in the calc tab. Can anyone tell me how to set up the
following w/o code or editing the sql? (Just using the Query Designer)

First Table : Members

Member_ID
-------------
Member1
Member2
Member3
Member4
Member5

Second Table : MemberGroups (A member can be in several groups at once)

MemberID GroupName
------------ -------------
Member1 Group1
Member1 Group2
Member2 Group2
Member3 Group3
Member4 Group4
Member5 Group5

Let's say I join on MemberID...I've tried all of the different types of
joins. I want back all members that are NOT in 'Group1'...problem is, since
Member1 is in 'Group2' also, they show up on the report. How can I set this
up so that any member that is in 'Group1' (regardless of other groups) is
completely excluded from the report?

Thanks In Advance,
Stacey

nardmoseley

If you update to RB 7.03 you can specify a SQL statement as a search value.

Thus you can add a search condition on MemberID and use the Not InList
operator. For the search value you can specify (Select MemberID from
MemberGroups where GroupName = Group1).



--

Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com