Hello Group,


I am trying to insert new meetuniq values into the stusched table.
The meetuniq field denotes a time,day of the week,and a specific schoolyear
They are going from 8 meetuniqs per week at the local districts to 4 meetuniqs at
the Career Center The meetuniqs at the career center are different for the same class
and period, then those at the local district.

I am trying to create a new table with the correct meetuiques for the career
center.

tmpStusched data ( temporary data from the home district )
LastName FirstName SectionN Coursec
Smith Joe 1 2T6
Jones Jim 1 2T6
LaFleur Karen 1 2T6

I have created a table call CCmeetuniq with the following data

meetuniq sectionN Coursec
100056 1 2T6
100057 1 2T6
100058 1 2T6
100059 1 2T6

What would be the best way to create a table cisStucsched with the following
data

LastName FirstName meetuniq Section Coursec
Smith Joe 100056 1 2T6
Smith Joe 100057 1 2T6
Smith Joe 100058 1 2T6
Smith Joe 100059 1 2T6
Jones Jim 100056 1 2T6
Jones Jim 100057 1 2T6
Jones Jim 100058 1 2T6
Jones Jim 100059 1 2T6
LaFleur Karen 100056 1 2T6
LaFleur Karen 100057 1 2T6
LaFleur Karen 100058 1 2T6
LaFleur Karen 100059 1 2T6


Thanks
Jim