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
--sb--
