Suppose I have two tables (Emp and EmpCopy) in sql server database with following data:

Case 1:  Data in Emp and EmpCopy  table present like below:

Table:  Emp

Id            Name

----------------------

1              Emp_Name

2              Emp_Age

3               Emp_City

Table: EmpCopy

Id            Name

--------------------

1              Emp_Name

2              Emp_Age

Case 2: Data in Emp and EmpCopy table present like below:

Table:  Emp

Id            Name

--------------------

1              Emp_Name

2              Emp_Age

Table: EmpCopy

Id            Name

---------------------

1              Emp_Name

2               Emp_Age

3               Emp_City

Now according to cases given above I want retrieve records from both the tables, just like given below

Case 1:

Id            Emp_Column    EmpCopy_Column

1              Emp_Name        Emp_Name

2              Emp_Age            Emp_Age

3              Emp_City             NULL

Case 2:

Id            Emp_Column    EmpCopy_Column

1              Emp_Name        Emp_Name

2              Emp_Age            Emp_Age

3              NULL                     Emp_City

Please reply ASAP.

Thanks in advance.