SQL Statement

[ganraj]

Hai,


I have a Access MDB and a table "Customer"

Fields are like this...

Cust_type, Invo_Number, Cust_number

The data in the table is like this....

3,1010001987,1000006
4,1010001987,1000006
3,1010001988,1000007
4,1010001988,1000007

Now I want to select distinct Invo_number and all the other fields in that record.

This will look like this....
3,1010001987,1000006
3,1010001988,1000007

Can anybody tell me How do I accomplish this with a SQL Statement?



------------------
ganraj.

[Serge]

Select Distinct Cust_type, Invo_Number, Cust_number From Customer

Regards,

------------------

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com

[ganraj]

Hello Serge,

That doesn't fulfil my need.

I have multiple entries of same invo_number and cust_number. How do I pick only one record related to a invo_number?




------------------
ganraj.

[Clunietp]

I think it's SELECT DISTINCTROW, not just DISTINCT....??

[JHausmann]

DISTINCTROW is going to omit the details he (?) wants. You need to give more details on what you're trying to do.