How to create a new column from values in two existing columns

[Anonymous]

I have two tables:

Table1:

SNo, Field1, Field2

1, A, B

2, C, D

3, E, F

Table2:

SNo, Field3, Field4

1, Id1, I

1, Id2, J

2, Id1, K

2, Id2, L

3, Id1, M

3, Id2, N

Is there a way to create a new table that should look like

Table3:

SNo, Field1, Field2, Id1, Id2

1, A,B,I, J

2, C,D, K, L

3, E,F, M, N