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
No. | Subject |
---|---|
Notice | Certification Oracle SQL Developer |
154 | TECH on the Net |
153 | trim(to_char(:P113_REGULAR,'999G999G999G999G990D00')) |
152 | PIVOT |
151 | TEST 2 |
150 | CREATION DEDUCTION TYPE |
149 | PL/SQL for creation Tables |
148 | TEST 1 |
147 | INNER JOIN & GROUP BY |
146 | DISPLAY ONLY FEW ROWS |
145 | GROUP BY (for CHART) |
» | INNER JOIN |
143 | LOOP - 2 |
142 | DATE Compare & Convert |
141 | LOOP & ROWNUM |
140 | Oracle Number Format |
139 | Page Reload in APEX |
138 | SUM / GROUP BY |
137 | MEDWIGS DB |
136 | HOW TO CONVERT DD/MM/YYYY -> MM/DD/YYYY |
135 | Attributes - Link Icon |