Hi..I am fairly new to SQL and need some help writing a script.
I have 2 tables
table 1 is the student data and table 2 is the student schedule data. In table 2 the students have a student id number that is teh same as the student id in table 1. Table 1 also has a student number that is linked to teh student id.
I need to pull all of the columns from the student schedule table 2and I just want the student number that corresponds to the student id pulled from the student table1.
My end result she be a table with all the columns from table 2 (studnet schedule) and the studnet number column from the student table. (table 1)
Any help would be GREATLY appreciated