most work already done sql plus
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.