CodingForums.com - View Single Post - Issue with DISTINCT and ORDER BY with UNION

Old Pedant · 10-04-2012, 01:01 AM

Part of your problem is your data: You have both a comment and a reply for post #3 that happen at exactly the same time.

But I think my MAX( ) trick will take care of this, regardless.

10-04-2012, 01:01 AM	PM User \| #12
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,187 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	Part of your problem is your data: You have both a comment and a reply for post #3 that happen at exactly the same time. But I think my MAX( ) trick will take care of this, regardless. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.