Append Values in Column from Table to Table In Kusto Control Command

Question

If I have table A that has a column of Student Id, and I have table B that also has Student Id Column, what's the control command that to copy all values of Student Id from Table A to Table B?

Answer 1

.set student2 <| print StudentID = "12345", StudentAddress = "MyLane, Mycity"

.set student1 <| print StudentID = "12345", StudentName = "John"

.set   tmp <| student1 | join kind=inner student2 on StudentID | project-away StudentID1

.drop table student1

.set student1 <| tmp

.drop table tmp