can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table?
christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder > they do different things, really. what are you trying to accomplish? > > christopher olive > cto, vp of web development, vp it security > atnet solutions, inc. > 410.931.4092 > http://www.atnetsolutions.com > > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 10:18 AM > To: CF-Talk > Subject: OT: UNION vs JOIN > > > Is there a significant difference in performance using a UNION on four > tables versus a JOIN on four tables? > > Thanks > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector v2.0 - Commerce Builder > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists