Most of the work is already done. SQL PLus

profileshall02

Check the lab document; specifically this part:

 

 

Patient              Doctor      Room       Admitted                       Required Medication

-------------------------------------------------------------------- -----------------------------------

1001 Fred          Payne        101    MARCH     31, 2004     2 Prozac           3 grams annually

                                                                                            6 Aspirin          1 gram  daily

                                                                                            9 Valium           2 grams weekly

 

The final product must look like that. The tables are already create but I need the SQL command to join all of them to look like the bit above.

 

 

  • 11 years ago
  • 20
Answer(0)
Bids(0)