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 -> Help!!! on SqlPlus query

Help!!! on SqlPlus query

From: Hongbo Zhang <hongbozhang_at_yahoo.com>
Date: Fri, 09 Apr 1999 12:44:46 GMT
Message-ID: <2DmP2.899$0C1.109214@carnaval.risq.qc.ca>


Hi,

I am new on Oracle. I have 4 following tables:

HOSPITAL:



CODE_H | NAME_H |

MEDECIN:



CODE_M | NAME_M |

HOS_MED:



CODE_H | CODE_M |

MED_PAT_HOS:



CODE_M | CODE_H | CODE_PATENT |

Would you please help me to realize this query with Oracle Sqlplus: for every MEDECIN,
find the name of hospital he works and count the nomber of patients he treats.

Thanks

Hongbo Received on Fri Apr 09 1999 - 07:44:46 CDT

Original text of this message

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