At 7:54 -0800 1/9/03, [EMAIL PROTECTED] wrote:
Hey all;
I am trying to work on a query that has SELECT DISTINCT * ..........
This does not work. While there is no error, the where clause causes repeats. I
do not really expect this to work, as DISTINCT needs a column to work with.
No, it doesn't. SELECT DISTINCT * should remove duplicates.
I am trying to avoid the workaround of putting in every column from the table in the select statement, so does anyone have any idea on how to keep the same row from coming up twice while still being able to use SELECT * ?? Mike Hillyer
--------------------------------------------------------------------- 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
