Source file :
EMP_BKUP.EMPNO AS EMP_ID,
EMP_BKUP.ENAME AS EMP_NAME,
EMP_BKUP.SAL1 as EMP_SAL,
EMP_BKUP.DEPTNO AS DEPTNO
FROM SRC.EMP_BKUP INNER JOIN SRC.DEPT ON EMP_BKUP.DEPTNODEPT.DEPT_ID
AND DEPT.DEPT_ID ?DEPT_ID?
the emp bakup and dept table DDL and insert statement are available in my previous video description , please take it from there , the video is
Take the opportunity to connect and share this video with your friends and family if you find it useful.