At 7:54 -0800 1/9/03, squeebee@stripped wrote:
>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
>do not really expect this to work, as DISTINCT needs a column to work with.
No, it doesn't. SELECT DISTINCT * should remove duplicates.
>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 * ??