For example. If you have these Q1, Q2, and Q3 datasets:
Q1 dataset : SELECT DEPARTMENT_ID, DEPARTMENT_NAME,LOCATION FROM DEPARTMENTS
Q2 dataset: SELECT EMPLOYEE_ID,FIRST_NAME,LAST_NAME,JOB,SALARY FROM EMPLOYEES Q3-dataset: SELECT JOB_ID,MAX_SALARY,MIN_SALARY FROM JOBS
Q3 dataset: SELECT JOB_ID,MAX_SALARY,MIN_SALARY FROM JOBS
Instead of linking the Q1, Q2, and Q3 datasets to form a parent-child hierarchy, create a single dataset combining the queries of Q1, Q2, and Q3 datasets as shown below:
WITH Q1 AS(SELECT DEPARTMENT_ID, DEPARTMENT_NAME,LOCATION FROM DEPARTMENTS),
Q2 AS (SELECT EMPLOYEE_ID, FIRST_NAME,JOB_ID AS EMP_JOB_ID,SALARY FROM EMPLOYEES),
Q3 AS(SELECT JOB_ID, MAX_SALARY,MIN_SALARY FROM JOBS)
SELECT Q1.*,Q2.*,Q3.* FROM Q1,Q2,Q3