Table: Doctor cCode cName A001 JOHN JONES Table: Treatment cCode cDesc PhyRate ClinicRate Srv01 ServiceA 20 80 Srv02 ServiceB 50 50 Table: Allowance cCode cDesc Rate A01 TRANSPORT 15.00 A02 MEAL 10.00 Table: Doctor_Treatment TreatCode DoctorCode Srv01 A001 Srv02 A001 Table: Doctor_Allowance AllowCode DoctorCode A01 A001 A02 A001 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 50I tried to group by AllowCode, but only one TreatCode will be appeared.. I want Srv01,Srv02 shown too..