How to join merge the data of two lists with same fields into a single list

[semsel]

I have two lists say

List 1:

EmpCode  | EmpName
1001           Smith
1002            Berry

List 2:

EmpCode | EmpName
1003           Joan
1004            Mini

Now I want to display it as :

EmpCode  | EmpName
1001           Smith
1002            Berry
1001           Smith
1002            Berry


Is there any way?

[squish88]

Assuming you meant that you wanted to display this:

EmpCode  | EmpName
1001           Smith
1002            Berry
1003           Joan
1004            Mini

You could use a union.

[ravimahazan84]

simply use the union if there is no common column in which u can join these two tables