Received: from megamail.dsl.net (megamail.dsl.net [209.87.64.97]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6DDama91253 for ; Fri, 13 Jul 2001 09:36:49 -0400 (EDT) (envelope-from james@lrgmail.com) Received: from jameslt (64-51-205-180.client.dsl.net [64.51.205.180]) by megamail.dsl.net (8.9.3/8.9.3) with SMTP id JAA04072 for ; Fri, 13 Jul 2001 09:36:43 -0400 Message-ID: <002301c10ba1$90872260$1600000a@lrg.office> From: "James Orr" To: References: <20010713102221.T415-100000@callisto.internal.linustech.com.cy> Subject: Re: Referencing a view? Date: Fri, 13 Jul 2001 09:41:16 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200107/168 X-Sequence-Number: 3960 Thanks for all the responses! The one from Grigoriy was particularly interesting, I hadn't thought of that approach. However, I came to the realization that if somebody changes their address, I don't want it to be changed on previous orders. So I think i'll change the orders table to contain the actual address information and use an INSERT ... SELECT instead. That way I can be sure I have an accurate record of all orders. Thanks! - James