Re: Reply from Drew

Post #204,376 by dws 4/21/05 8:17:36 PM Reply	Re: Reply from Drew How about something like select o.ordernum, count(e.status) from tbl_order o left outer join tbl_escalation e on o.ordernum = e.ordernum and e.status = 'open' group by o.ordernum order by o.ordernum You can then wrap count(e.status) in whatever formatting functions are available.
Post #204,377 by ben_tilly 4/21/05 8:36:52 PM Reply	You're ordering by the wrong thing Yes, you can order by the count(), but you're now subordering by the number of escalations and may want a different sort. That is why I did all of the CASE garbage in my solution. Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless.* -- Aaron Ward (my brother)
Post #204,436 by dws 4/22/05 12:38:23 PM Reply	Where do you see me ordering by count(*) ?
Post #204,487 by ben_tilly 4/22/05 2:08:36 PM Reply	You weren't, clarification He wanted it sorted by whether any tickets were open. You weren't sorting by that, you were sorting by ordernum. Hence the title of my post. I suggested that you could fix that to get something closer to what he wanted by sorting on count(), but it doesn't support exactly the sort that I think he would eventually decide that he wants. Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless.* -- Aaron Ward (my brother)
Post #204,514 by dws 4/22/05 4:32:31 PM Reply	Re: You weren't, clarification Damn. You're right. I skipped over the ordering requirement.

Welcome to IWETHEY!