Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help!!! on SqlPlus query
Hi,
I am new on Oracle. I have 4 following tables:
HOSPITAL:
MEDECIN:
HOS_MED:
MED_PAT_HOS:
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
![]() |
![]() |