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 >
