SQL Access List the medication prescribed for patients who are in for Compound Fracture; Show patient first and last name, gender, age, room number, medication code, and medication dosage. [Use join query]

IlIness Diagnosis Illness Code Illness Desc Department Pres No Patient N0 Medication Code Dosage Physician JD Last Name Patient-No ness Code Tel Extensian Specialty Assignment Paticnt Medication FnysicianJD Patient No Role patient No Last Name First Name Age Gentder Medicatian Cade On Hand On Order Unit Cost