Left Outer Join question - (ChrisR) - (20) - June 7, 2006, 10:26:29 PM EDT
         One approach - (ben_tilly) - (6) - June 8, 2006, 01:13:51 PM EDT
             Some variation on MIN... - (ChrisR) - (3) - June 8, 2006, 11:10:15 AM EDT
                 It probably will not optimize - (ben_tilly) - (2) - June 8, 2006, 01:27:27 PM EDT
                     Yep, took forever to run. - (ChrisR) - (1) - June 8, 2006, 02:00:51 PM EDT
                         Nothing non-standard about that - (drewk) - June 8, 2006, 02:40:14 PM EDT
             Pre indentation - (ChrisR) - (1) - June 8, 2006, 02:02:57 PM EDT
                 Bug, indentation can be lost during edits (new thread) - (ben_tilly) - June 8, 2006, 02:18:49 PM EDT
         Does SQL Server support "DISTINCT ON"? - (drewk) - (12) - June 8, 2006, 08:55:49 AM EDT
             That is really what I need! - (ChrisR) - June 8, 2006, 10:56:50 AM EDT
             The more readable version is invalid (at least in Oracle) - (ben_tilly) - (10) - June 8, 2006, 01:12:25 PM EDT
                 Hmm, both Postgres and MySQL support the same non-standard? - (drewk) - (9) - June 8, 2006, 01:49:01 PM EDT
                     Can you please help me find mine? - (folkert) - June 8, 2006, 02:04:49 PM EDT
                     That is a MySQL shortcut - (ben_tilly) - (7) - June 8, 2006, 02:14:38 PM EDT
                         Not surprising - (drewk) - (2) - June 8, 2006, 02:42:46 PM EDT
                             Or you didn't double-check enough - (ben_tilly) - (1) - June 8, 2006, 02:50:14 PM EDT
                                 Also possible - (drewk) - June 8, 2006, 04:17:32 PM EDT
                         I've encountered that problem. - (static) - (3) - June 8, 2006, 08:48:27 PM EDT
                             Justifiable arrogance in many cases - (ben_tilly) - (2) - June 8, 2006, 09:18:47 PM EDT
                                 Oh I have little doubt about that. - (static) - (1) - June 8, 2006, 09:35:59 PM EDT
                                     Oracle is picky but... - (ben_tilly) - June 8, 2006, 10:03:53 PM EDT