[cfaussie] Re: Someone help with this bit of code?

[Andrew Scott]

Andrew,   Order By doesn’t help, in the query I want to write it will always return 73 records. Now the original query is on a group by, and it returns 23 records dropping 50 records and I really don’t understand why there is a difference.   When looking at the records returned on both queries, and the original query is below. But with the cfoutput group by it drops 50 records that I can not for the life of me work out why, looking at these in the Enterprise Manager gives me no clues as to why there is a difference.   Original query that I am optimising               <cfquery datasource="#DSN#" name="BookingInfo">             SELECT *             FROM Bookings, BookingItems             WHERE BO_DeleteDate IS NULL             AND BO_ID = BI_BookingID             AND BI_ParentItem IS NULL             </cfquery>   Which is used by the cfoutput group=””     Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  8676 4223 Mobile: 0404 998 273   --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---