I have 2 SQL tables A and B.
A table has all the dates in "Date" column.
B table has different values in "CodeNo" column.
What I want to output is join "Date" column in A table to B table.
Create "Date_1" column for the first "CodeNo" if then create another "Date_2" column for the rest of the values in "Date" column in A table.
Is this possible?
Thank you for all your help.