I have tow tables, Table A has 3 columns as StudentID, Name, Course, ClassID and
Table B has many columns as StudentID, Name, Other1, Other2, Other3 ...
I want convert Table A to Table B.
Please help me!
Table A
StudentID Name Course ClassID
85001
David Data Base 11
85001
David Data Structure 22
85002 Bob Math 33
…