Help!!! on SQLPlus query
From: Hongbo Zhang <hongbozhang_at_yahoo.com>
Date: Fri, 09 Apr 1999 12:56:30 GMT
Message-ID: <2OmP2.906$0C1.109389_at_carnaval.risq.qc.ca>
Hi,
CODE_H | NAME_H |
CODE_M | NAME_M |
CODE_H | CODE_M |
CODE_M | CODE_H | CODE_PATENT |
Date: Fri, 09 Apr 1999 12:56:30 GMT
Message-ID: <2OmP2.906$0C1.109389_at_carnaval.risq.qc.ca>
Hi,
[Quoted] 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 - 14:56:30 CEST