Hi Nick, grrr! This was the first thing I tried, but I must have had something else dodgy in there from other attempts because it didn't work! And I just changed everything this morning to work with 2 queries in case I didn't have time to work it out in one.... argh. thanks m8y ;)
cheers, Toby Friday, September 19, 2003, 9:21:51 AM, you wrote: NG> Toby NG> I'd suggest that you need to do a left outer join on the client_id from the NG> sub query. That should return NULL where the multiple count does not exist NG> and depending on which DB you use you can manipulate the NULL to a 0 (using NG> a case or if statement in SQL Server). NG> -----Original Message----- NG> From: [EMAIL PROTECTED] NG> [mailto:[EMAIL PROTECTED] On Behalf Of Toby Tremayne NG> Sent: Friday, 19 September 2003 8:58 AM NG> To: CFAussie Mailing List NG> Subject: [cfaussie] Re: OT: sql question again NG> Hi Gary, NG> yeah I've got something working at the moment with two queries, but NG> it's bugging me now, I'm sure there must be a way to do it in one NG> query ;) NG> cheers, NG> Toby NG> Friday, September 19, 2003, 8:41:18 AM, you wrote: >>> to clarify that - I need it to come back with a multipleCount of 0 >>> when there are no multiple inspection sets, and still return the >>> other stuff. GM>> I haven't read this through in detail again..... GM>> ....just do two queries - dont try and get it all returned in one GM>> chunk. GM>> Gary Menzel GM>> Web Development Manager GM>> IT Operations Brisbane -+- ABN AMRO Morgans Limited GM>> Level 29, 123 Eagle Street BRISBANE QLD 4000 GM>> PH: 07 333 44 828 FX: 07 3834 0828 GM>> ******************************************************************** GM>> ******** GM>> If this communication is not intended for you and you are not an NG> authorised GM>> recipient of this email you are prohibited by law from dealing with or GM>> relying on the email or any file attachments. This prohibition includes GM>> reading, printing, copying, re-transmitting, disseminating, storing or NG> in GM>> any other way dealing or acting in reliance on the information. If you GM>> have received this email in error, we request you contact ABN AMRO NG> Morgans GM>> Limited immediately by returning the email to [EMAIL PROTECTED] GM>> and destroy the original. We will refund any reasonable costs associated GM>> with notifying ABN AMRO Morgans. This email is confidential and may NG> contain GM>> privileged client information. ABN AMRO Morgans has taken reasonable NG> steps GM>> to ensure the accuracy and integrity of all its communications, NG> including GM>> electronic communications, but accepts no liability for materials GM>> transmitted. Materials may also be transmitted without the knowledge of NG> ABN GM>> AMRO Morgans. ABN AMRO Morgans Limited its directors and employees do NG> not GM>> accept liability for the results of any actions taken or not on the NG> basis GM>> of the information in this report. ABN AMRO Morgans Limited and its GM>> associates hold or may hold securities in the companies/trusts mentioned GM>> herein. Any recommendation is made on the basis of our research of the GM>> investment and may not suit the specific requirements of clients. GM>> Assessments of suitability to an individual's portfolio can only be made GM>> after an examination of the particular client's investments, financial GM>> circumstances and requirements. GM>> NG> **************************************************************************** GM>> --- GM>> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To GM>> unsubscribe send a blank email to GM>> [EMAIL PROTECTED] GM>> MX Downunder AsiaPac DevCon - http://mxdu.com/ NG> -------------------------------- NG> Life is Poetry, NG> write it in your own words NG> -------------------------------- NG> Toby Tremayne NG> Cold Fusion Developer NG> Code Poet and Zen Master of the Heavy Sleep NG> Virtual Tours NG> +61 416 048 090 NG> ICQ: 13107913 NG> --- NG> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To NG> unsubscribe send a blank email to [EMAIL PROTECTED] NG> MX Downunder AsiaPac DevCon - http://mxdu.com/ NG> --- NG> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] NG> To unsubscribe send a blank email to [EMAIL PROTECTED] NG> MX Downunder AsiaPac DevCon - http://mxdu.com/ -------------------------------- Life is Poetry, write it in your own words -------------------------------- Toby Tremayne Cold Fusion Developer Code Poet and Zen Master of the Heavy Sleep Virtual Tours +61 416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
