Dale, Not my code, but before I clean it up properly I need to know why there is a difference.
And even with the inner joins it still doesn't match the difference to using the cfoutput group="", the code you posted Dale is the code I did write, and it returned 73 records, as well as the code I posted 73 records. The original query without the extra and the group attribute and with the cfif and cfelse returnes 23 records. And I don't understand what the difference is between doing it entirely in the SQL and doing it via a group attribute on the cfoutput? 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
