Convert Normalize table to Unormalize table
- by M R Jafari
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
85002 Bob Data Base 44
85002 Bob Data Structure 55
85002 Bob C# 66
85003 Sara C# 77
85003 Sara Data Base 88
85004 Mary Math 99
85005 Mary Math 100
…
Table B
SdentdID Name Other 1 Other 2 Other 3 Other 4 …
85001 David DBase,11 DS,22
85002 Bob Math,33 DB,44 DS,55 C#,66
85003 Sara C#,77 DBase,88
85004 Mary Math,99
