Hi Hilmar,

That worked well

Thank you very much
Jim



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

>select tmpStusched.LastName, tmpStusched.FirstName, CCmeetuniq.MeetUniq;
>  from TmpStusched, CCmeetUniq
>

>
>Note the missing WHERE clause! Every record from Table1 will be combined with every record from Table2. This is called a Cartesian Product.
>
>In most cases, this Cartesian Product is the result of a programming mistake - but sometimes, as here, it is required. Because the Cartesian Product is often the result of a careless mistake, you should include a comment, stating that it is on purpose.
>
>HTH, Hilmar.