Hi,

The below is the query that I have:

SELECT A.EMP_NO, A.EMP_NAME, A.EMP_SAL
B.EMP_NO, B.EMP_NAME, B.EMP_SAL
FROM ((SELECT EMP_NO
,EMP_NAME
,EMP_SAL
FROM EMPLOYEE_DTL1) AS A
FULL OUTER JOIN
(SELECT EMP_NO
,EMP_NAME
,EMP_SAL
FROM EMPLOYEE_DTL2) AS B)...