Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help!!! on SqlPlus query

Re: Help!!! on SqlPlus query

From: Miroshnichenko Roman <kovbasuk_at_cbsd.donetsk.ua>
Date: Fri, 9 Apr 1999 18:02:28 +0300
Message-ID: <7el4ub$spr$1@usb.dipt.donetsk.ua>

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
WHERE gr.Code_h=h.Code_h

      AND gr.Code_m=m.Code_m
ORDER BY 1,2; Best regards! Received on Fri Apr 09 1999 - 10:02:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US