Link to home
Start Free TrialLog in
Avatar of Brian
BrianFlag for United States of America

asked on

help with retrieving data from multiple tables

Hello Experts,

Please see my Database Scheme below. I need to retrieve all information from the HealthCourses_CourseSchedules Table that relate to ghaocp_id & ghaoc_id from the HealthCourses_GeneralHealthAwarenessOneCoursesPrograms Table and I need to know the hmi_name from the HealthCourses_HighmarkInstructors.

HealthCourses_GeneralHealthAwarenessOneCourses
ghaoc_id     ghaco_name

HealthCourses_GeneralHealthAwarenessOneCoursesPrograms
ghaocp_id     ghaoc_id     ghaocp_name

HealthCourses_CourseSchedules
csch_id     ghaoc_id     ghaocp_id     hmi_id

HealthCourses_HighmarkInstructors
hmi_id     hmi_name
ASKER CERTIFIED SOLUTION
Avatar of Daniel Reynolds
Daniel Reynolds
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial