CREATE TABLE IF NOT EXISTS `YXUE_Registrar-Data-2020`.`tblEnrollments` (
` Subj` varchar(4),
`#` varchar(3),
`Title` varchar(30),
`Comp Numb` int(5),
`Sec` varchar(3),
`Ptrm` varchar(1),
`Lec Lab` varchar(4),
`Attr` varchar(4),
`Camp Code` varchar(1),
`Coll Code` varchar(5),
`Max Enrollment` int(3),
`Current Enrollment` int(3),
`True Max` varchar(3),
`Start Time` varchar(5),
`End Time` varchar(5),
`Days` varchar(10),
`Credits` varchar(9),
`Bldg` varchar(6),
`Room` varchar(9),
`GP Ind` varchar(1),
`Instructor` varchar(35),
`NetId` varchar(8),
`Email` varchar(35),
`Fees` varchar(68),
`XListings` varchar(116))
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
INSERT INTO `YXUE_Registrar-Data-2020`.`tblEnrollments` (
` Subj`,
`#`,
`Title`,
`Comp Numb`,
`Sec`,
`Ptrm`,
`Lec Lab`,
`Attr`,
`Camp Code`,
`Coll Code`,
`Max Enrollment`,
`Current Enrollment`,
`True Max`,
`Start Time`,
`End Time`,
`Days`,
`Credits`,
`Bldg`,
`Room`,
`GP Ind`,
`Instructor`,
`NetId`,
`Email`,
`Fees`,
`XListings`)
VALUES (
'ANFS',
'491',
'Doctoral Dissertation Research',
90005,
'A',
'1',
'TD',
'',
'M',
'CALS',
20,
0,
'',
'TBA',
'',
' ',
'1 to 18',
'',
'',
'N',
'Harvey, Jean Ruth',
'jharvey',
'Jean.Harvey@uvm.edu',
'',
' ')
SELECT `pfkStudentNetId`,`pfkEnrollmentId`,`pmkNetId`,`fldLastName`,`fldFirstName`,`fldMiddleName`,`pmkEnrollmentId`,`Subj`,`#`,`Title`,`Start Time`,`End Time`,`Days`,`Bldg`,`Room`,`Instructor`
FROM`tblStudentEnrollments`
JOIN `tblStudents` ON `pmkNetId` = `pfkStudentNetId`
JOIN `tblEnrollments` ON `pmkEnrollmentId` =`pfkEnrollmentId`
WHERE`pfkStudentNetId` LIKE 'yxue'