Thank you Dan, David and Javier!
The autonumber function is all right now and so also the APPEND command, but when I come home I'll try David's R>CREATE temp view ... in order to learn something really new.
Bo
Javier Valencia wrote:
Bo: JOIN does a side-by-side merge, if you have all similar columns, maybe what you need is APPEND??? Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bo Franzén Sent: Thursday, December 09, 2004 7: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
