Brian
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_CourseSchedu les Table that relate to ghaocp_id & ghaoc_id from the HealthCourses_GeneralHealt hAwareness OneCourses Programs Table and I need to know the hmi_name from the HealthCourses_HighmarkInst ructors.
HealthCourses_GeneralHealt hAwareness OneCourses
ghaoc_id ghaco_name
HealthCourses_GeneralHealt hAwareness OneCourses Programs
ghaocp_id ghaoc_id ghaocp_name
HealthCourses_CourseSchedu les
csch_id ghaoc_id ghaocp_id hmi_id
HealthCourses_HighmarkInst ructors
hmi_id hmi_name
Please see my Database Scheme below. I need to retrieve all information from the HealthCourses_CourseSchedu
HealthCourses_GeneralHealt
ghaoc_id ghaco_name
HealthCourses_GeneralHealt
ghaocp_id ghaoc_id ghaocp_name
HealthCourses_CourseSchedu
csch_id ghaoc_id ghaocp_id hmi_id
HealthCourses_HighmarkInst
hmi_id hmi_name
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.