How to do without subqueries - (drewk) - (18) - April 21, 2005, 12:02:47 AM EDT
         SELECT DISTINCT t1.* FROM t1, t2 ...? - (FuManChu) - April 21, 2005, 01:26:10 AM EDT
         I don't understand your description - (ben_tilly) - (16) - April 21, 2005, 02:21:36 AM EDT
             Reply from Drew - (Meerkat) - (15) - April 21, 2005, 09:34:14 AM EDT
                 Re: Reply from Drew - (SpiceWare) - (6) - April 21, 2005, 09:59:22 AM EDT
                     DECODE is Oracle-specific. -NT - (ben_tilly) - (5) - April 21, 2005, 08:37:47 PM EDT
                         It is, but it is easy to clone - (tuberculosis) - April 22, 2005, 09:29:35 AM EDT
                         Are you sure? I checked MySQL before posting - (SpiceWare) - (3) - April 22, 2005, 09:54:09 AM EDT
                             They may have added it but it is not standard - (ben_tilly) - April 22, 2005, 11:16:56 AM EDT
                             Seems to be specific to MaxDB - (JayMehaffey) - (1) - April 22, 2005, 11:35:10 AM EDT
                                 That's rather confusing - (SpiceWare) - April 22, 2005, 12:14:55 PM EDT
                 One solution - (JayMehaffey) - (1) - April 21, 2005, 10:25:00 AM EDT
                     FWIW this was the best I saw for our needs - (drewk) - April 21, 2005, 08:49:39 PM EDT
                 Untested, googling for supported syntax - (ben_tilly) - April 21, 2005, 10:32:29 AM EDT
                 Re: Reply from Drew - (dws) - (4) - April 21, 2005, 08:17:36 PM EDT
                     You're ordering by the wrong thing - (ben_tilly) - (3) - April 21, 2005, 08:36:52 PM EDT
                         Where do you see me ordering by count(*) ? -NT - (dws) - (2) - April 22, 2005, 12:38:23 PM EDT
                             You weren't, clarification - (ben_tilly) - (1) - April 22, 2005, 02:08:36 PM EDT
                                 Re: You weren't, clarification - (dws) - April 22, 2005, 04:32:31 PM EDT