sounds like a simple coding error, show us your code. yeah, I know we already saw the code, but show us what YOU coded, including the output.
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Allan Cliff" <allan@redpro To: <[EMAIL PROTECTED]> .net> cc: Subject: Re: [ cf-dev ] SQL question - brain a blank! 09/19/02 02:33 PM Please respond to dev The LEFT JOINS don't seem to work. The query counts the tables and whichever has the highest value gets set for all the counts. ----- Original Message ----- From: Rich Wild To: '[EMAIL PROTECTED]' Sent: Thursday, September 19, 2002 3:12 PM Subject: RE: [ cf-dev ] SQL question - brain a blank! run the query analyser to see which is quicker.... > -----Original Message----- > From: Stephen Moretti [mailto:[EMAIL PROTECTED]] > Sent: 19 September 2002 14:19 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] SQL question - brain a blank! > > > > > > left joins are very resource intensive. should always be avoided if > > possible. > > > > Though not as intensive as 4 SELECTs in one statement. > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
