Hi,
I have 4-5 tables. I want to join each other.
The first three courses, organization, and registrations are linked together by courseid and orgid.
The fourth is linked by hrid.
How do I link the table hr_positions and department as they are not linked to tblcourses but linked to human_resources table?
Qualify*;
tblCourses:
LOAD "COURSE_ID" as CourseId,
DESCRIPTION,
"ORG_ID" as OrgId,
SQL SELECT *
FROM COURSES
where COURSE_TYPE='W';
left join (tblCourses)
LOAD "ORG_ID" as OrgId,
"ORG_NAME",
SQL SELECT *
FROM ORGANISATIONS;
left Join (tblCourses)
LOAD "COURSE_ID" as CourseId,
"HR_ID" as HRID;
SQL SELECT *
FROM REGISTRATIONS;
HUMAN_RESOURCES:
left join (tblCourses)
LOAD "HR_ID" as HRID,
SQL SELECT *
FROM "HUMAN_RESOURCES";
Left join (tblcourses) --- How do I join HRID to above registration table
LOAD "pid" as Pid,
"hr_id" as HRID;
SQL SELECT *
FROM hr_positions;
left join (tblCourses)
LOAD "pid" as pid,
Description,
SQL SELECT *
FROM department;
