Hi Rohit,
Considering your First Case, Here is the Query
SELECT A.ID,A.NAME,B.NAME FROM EMP A LEFT OUTER JOIN EMPCOPY B ON A.ID = B.ID AND A.NAME =B.NAME
And the Second case which is a little reverse of First One,
So I have used the Same Tables but changing the Type of Join
SELECT B.ID,A.NAME,B.NAME FROM EMPCOPY A RIGHT OUTER JOIN EMP B ON A.ID = B.ID AND A.NAME =B.NAME
Ideally, If you consider only the ID Column in both tables then, the query turns out to be
First Case,
SELECT A.ID,A.NAME,B.NAME FROM EMP A LEFT OUTER JOIN EMPCOPY B ON A.ID = B.ID
Second Case,
SELECT B.ID,A.NAME,B.NAME FROM EMPCOPY A RIGHT OUTER JOIN EMP B ON A.ID = B.ID
Thanks,
Shankar