I don't see why. He is talking about an update/insert form with a select populated by authors. To Let's say we have 100 authors, this would mean that we get the article info 100x. We also need to make an outer join to get all the authors.
For such a form: 1 query to get the article's data & 1 query to get the authors to fill the select. Pascal > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: 09 November 2004 20:02 > To: CF-Talk > Subject: RE: When two tables go to war (JOIN) > > Doesn't that create more overhead? > > Ray > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183784 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
