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