Information générale
Forum:
Microsoft SQL Server
Titre:
Combinig two tables in SQL 7.0
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement