Wade, You tell DISTINCT which columns you want it to look at. So you can ignore the columns that you don't care about.
Sorry for the top post. I sent this from my phone. Dave On Jan 14, 2009 6:37 PM, "Wade Preston Shearer" <[email protected]> wrote: On 14 Jan 2009, at 17:08, Brandon Stout wrote: > Have you tried SELECT DISTINCT instead of GROUP BY... According to my understanding, DISTINCT eliminates duplicate rows and in my case my rows are similar but not unique (one column is different), DISTINCT will not help. _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
