You will have to manually autonumber the PK column after you project the new table. If you look carefully at the new table you will notice that only the column structure was projected, no indexes or autonumbers.
--- Bo Franz�n <[EMAIL PROTECTED]> wrote: > Thank you David and Dan! > > I am on the brink to create my new table by APPEND (or CREATE temp view) > and everything is OK except for a very last snag the last hour is that > the second table (containing imported stuff from a text file) "refuses" > to auto number, instead that INTEGER column (should be primary&unique) > just contains NULL. > > Bo > > David M. Blocker wrote: > > >Bo > > > >Create temp VIEW zTemp AS SELECT t1.col1, t2.col2, t1.col3,t2.col4 from > >Table1 T1, Table2 T2 WHERE T1.CommonCol = T2.CommonCol > > > >PROJECT newtab FROM zTemp USING ALL > > > >David Blocker > >[EMAIL PROTECTED] > >781-784-1919 > >Fax: 781-784-1860 > >Cell: 339-206-0261 > >----- Original Message ----- > >From: "Ron Gries" <[EMAIL PROTECTED]> > >To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > >Sent: Thursday, December 09, 2004 8:30 AM > >Subject: [RBG7-L] - Re: JOIN command problem > > > > > >Maybe I'm wrong about your question Bo. But if both table columns are the > >same, why not "append table2 to table1". > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bo Franz�n > >Sent: Thursday, December 09, 2004 6:11 AM > >To: RBG7-L Mailing List > >Subject: [RBG7-L] - Re: JOIN command problem > > > >Dan, But I want to join all four columns in the two tables forming a new > >table, not only joining only one single column. Seems to me that the JOIN > >command is not suitable for that, but there must be another way to go. > > > >Bo > > > > > > > >Dan wrote: > > > > > > > >>I believe you only specify the column you wish to compare rather than > >>all, or a list. ie > >> > >>JOIN table1 USING columnam1 WITH table2 USING columname1 FORMING table3. > >> > >>At 06:52 AM 12/9/2004, you wrote: > >> > >> > >> > >> > >>>I have two tables with identical Column Names and Data types. Now I > >>>have failed in joining them at the prompt: > >>> > >>>R>JOIN table1 USING ALL WITH table2 USING ALL FORMING table3. > >>> > >>>I also in vain tried to specify the columns: > >>> > >>>R>JOIN table1 USING column1,column2,column3,column4 WITH table2 USING > >>>column1,column2,column3,column4 FORMING table3. > >>> > >>>What's wrong with my syntax? Is there another way to go to create > >>>table3? > >>> > >>>Bo Franz�n > >>> > >>> > >>Thanks, > >> > >>Dan > >> > >>Dan Champion > >>Information Services > >>Service Coordinator > >>Vredevoogd Heating > >>3047 Sangra SW > >>Grandville, MI 49504 > >>(616) 534-8271 x10 > >>www.vredevoogd.com > >>www.championsolutions.net > >> > >> > >> > > > > > > > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
