Skip to Content
0
Former Member
Apr 23, 2007 at 03:55 PM

Subset only selection

10 Views

Post Author: rookie10

CA Forum: Data Connectivity and SQL

I have three linked tables and am trying to select record ID's which were modified by somone with role of only F. I keep getting records also modified by Joe as F is included in his set of roles. I tried selecting on all but F but that doesn't seem to work either. Any help would be appreciated. I am using Crystal Reports 10.

Rookie

Table 1

Person

Role

Cathy

A

Cathy

B

Cathy

C

Cathy

D

Joe

A

Joe

B

Joe

F

Dave

F

Table 2

Person

User ID

Cathy

100

Joe

200

Dave

300

Table 3

Record ID

Last modified by

1001

100

1002

200

1003

200

1004

300

1005

300