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