Including all not Excluding all

building reports desktopintelligence
1

THANK YOU!!! That worked perfectly. I had tried a sub query but not through
a condition. Thanks

From: Baranowski, George[SMTP:GBaranowski@QUADRAMED.COM]
Sent: Monday, April 12, 1999 11:15 AM

Have you tried using a condition with a subquery?

Select Object1 through ObjectN as Result Objects and create a condition
using a unique identifying element (like Account Number) for your records.
Use the In List operator and “Create a Subquery” operand.

This results in a subquery Query Panel with the Account Number as a Result
Object. Create a conditon where Object1 is equal to your desired value.

This will retrieve all Object1 through ObjectN for records where one of
them
meets the condition in your subquery.

Listserv Archives (BOB member since 2002-06-25)