Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help!!! on SqlPlus query
Try it:
SELECT m.Name_m, h.Name_h, gr.Count_pat FROM Hospital h, Medicin m, (SELECT Code_m, Code_h, count(Code_p) as Count_pat
FROM Med_pat_hos GROUP BY Code_m,Code_h) gr
AND gr.Code_m=m.Code_m
ORDER BY 1,2;
Best regards!
Received on Fri Apr 09 1999 - 10:02:28 CDT
![]() |
![]() |