admin 2020.10.05 09:06 Views : 75
SELECT p.Par_Id, p.Pat_Name, p.Pat_Gender, h.His_Id, h.Treated_By, t.Treat_Id, t.Treat_Type, t.Charges FROM Patient p INNER JOIN History h ON p.PAR_ID = h.PAT_ID INNER JOIN Treatment t ON h.HIS_ID = t.HIS_ID AND p.PAR_ID = h.PAT_ID