Skip to Content
Former Member
May 29, 2008 at 04:34 PM

Join problem


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?