Skip to Content
0
Former Member
Nov 11, 2012 at 11:18 PM

Intersection between three queries.

80 Views

Hi All,

i am stuck with a problem where i have data coming from three classes from the same universe.

Three Classes are

1. Member

2. Medical

3. Pharmacy

Here all the Data that i have to show in the report comes from Member class. All three classes have object MemberNumber and incurred dates.

I have to show MemberNumber of Member class that are not in MemberNumber of Medical and Pharmacy class.

basically we can say MemberNumber(Member) Not In MemberNumber (Medical, Pharmacy) based on incurred dates

i am wondering how to do this. Please suggest

Thank You