Really Easy Query

fabby1 · Oct 31, 2004

Hi

I have a table of data that contains exact duplicates. What I want to do is create a query that includes EVERYTHING but but one occurance of the duplicate.

Hp you can help

Thanks

Phil

KenReay · Oct 31, 2004

Have you tried:

SELECT DISTINCT ... blah... FROM blah...

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

fabby1 · Oct 31, 2004

Thanks Ken

Easy when u know how

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Really Easy Query

fabby1

Technical User

KenReay

Programmer

fabby1

Technical User

Similar threads

Part and Inventory Search

Sponsor