Information générale
Catégorie:
Gestionnaire de rapports & Rapports
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement