select * from Student join Course on Student.SameCol1=Course.SameCol1
--I am assuming the column names SELECT * FROM Students AS S INNER JOIN Course AS C ON S.CourseID = C.ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)