Query Question

[sturner333]

I have a query that one of the fields can have repeated values because it is repeated in the table it comes from. I would like to only have one of the repeated fields.
For example:

1000 1330 Bob Lowman 1330
7000 7110 Steve Quast 7110
7000 7110 Steve Quast 7110
7000 7110 Steve Quast 7110
7000 7120 Steve Quast 7120

I would like:

1000 1330 Bob Lowman 1330
7000 7110 Steve Quast 7110
7000 7120 Steve Quast 7120

Thanks for the help!

 

[lespaul]

how about:

SELECT DISTINCT * FROM [b]TableName[/b]

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[fneily]

Curious, why do you have duplicate data?

 

[sturner333]

Because there is a sub category under this one.

 

[fneily]

So? There still should be no duplicates in tables.

Fundamentals of Relational Database Design

http://r937.com/relational.html

Just something to learn.