If you have to have a third table then copy table1 to table3 and then append table2 to table3.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Gries Sent: Thursday, December 09, 2004 6:31 AM To: RBG7-L Mailing List 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 >
