Post Author: lab
CA Forum: General
Using Crystal 9
I have 3 tables with the following fields and data
Case PerCase mpmas
Case# Case# Emp# Procedure Emp# Name Role
123 123 444 abc 444 John Nurse
123 123 555 abc 555 Mary Surgeon
987 987 777 ghi 777 Joe Nurse
987 987 888 ghi 888 Nancy Anes
My problem is I need all the cases in Case Table, All the Cases in PerCase and only the cases with a Role of Anes in the Empmas table so my data should look like:
Case# Proc Anes
123 abc
987 ghi Nancy
I can't figure out how to do the joins to get these results. Any ideas?