Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two tables, one with 2 columns and other with 3 coulmns. In second table 1 coulmn in merger of columns of first table. We want to combine the two tables in a way that first table-two columns and second tables 2 two columns come together. The column which is merger of two columns of will not be in the output but the data maps correctly.
We have tried to do this with help of two join. However is there any other optimal solution ?
Please find attached example for same.
Thanks,
Nish
Thanks Mohit,Deepak and Martyn.
Nisha