At 7:54 -0800 1/9/03, squeebee@stripped 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
