Paul, > DISTINCT removes duplicates: rows that are the same in *all* columns.
Would this be all columns in the table, or all columns retrieved by the SELECT statement? TIA. - Sheryl sql,query,queries,smallint ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Sheryl Canter" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Frank Peavy" <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 12:34 PM Subject: Re: SELECT DISTINCT question At 11:50 -0500 2/28/03, Sheryl Canter wrote: >Frank, > >Sorry that I seem to be explaining this so poorly. I'll try to clarify what >I'm trying to do and what my questions are. Someone on this list did give me >code that I think will work. I haven't had a chance to try it yet. > >My question about how DISTINCT works is this: does it operate on the *result >set*? So depending on my SELECT statement and which fields I bring in, >different rows may be distinct? It's my guess that it works this way. I want >to confirm. DISTINCT removes duplicates: rows that are the same in *all* columns. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php