That was an amazingly vage question. But first thoughts would be yes and no. You can do grouping, but you can't really do it conditionaly with out code. SQL dosn't support much in the way of logic. So, basicly you do the "conditional" part in code, then the grouping with SQL. If you want the data grouped depending on values in the data then you will probably need more then one SQL. An SQL result set is eigther grouped/ordered or its not. You can't have it both ways......
Hayides Ess Que what? sorry, my brain just zoned out for a second..... ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 11:40 AM Subject: Re: Custom/conditional grouping? : David Garamond <[EMAIL PROTECTED]> wrote: : > Can I do this with in pure SQL (instead of having to create logic in : > programming language)? : > : : What do you mean "Custom/conditional grouping"? Please, be more detailed. : : : -- : For technical support contracts, goto https://order.mysql.com/?ref=ensita : This email is sponsored by Ensita.net http://www.ensita.net/ : __ ___ ___ ____ __ : / |/ /_ __/ __/ __ \/ / Victoria Reznichenko : / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] : /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net : <___/ www.mysql.com : : : : : : -- : MySQL General Mailing List : For list archives: http://lists.mysql.com/mysql : To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] : : -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
