In the results generated, it shows both allowances allocated to each of the treatments. However, you said that you want the allowance A01 allocated to the treatment Srv01 and the allowance A02 allocated to treatment Srv01. How do you know which allowance is supposed to appear with each treatment if they are not related?

Steven T. Cameron


Result generated by joining all tables
DoctorCode DoctorName AllowCode AllowanceRate TreatCode PhyRate ClinicRate
A001 JOHN JONES A01 15.00 Srv01 20 80
A001 JOHN JONES A02 10.00 Srv01 20 80
A001 JOHN JONES A01 15.00 Srv02 50 50
A001 JOHN JONES A02 10.00 Srv02 50 50

But I want to show it like:
DoctorCode DoctorName AllowCode AllowanceRate TreatCode PhyRate ClinicRate
A001 JOHN JONES A01 15.00 Srv01 20 80
A001 JOHN JONES A02 10.00 Srv02 50 50