As Always
Thanks
Jim
>Try
Select ts.LastName, ts.FirstName, mt.meetuniq, ;
> ts.Section, ts.Coursec ;
> FROM tmpStusched ts ;
> JOIN CCmeetuniq ON mt.Coursec = ts.Coursec AND mt.Section = ts.Section ;
> INTO TABLE cisStucsched
>
>>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
