Printable View
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.
Select Distinct Cust_type, Invo_Number, Cust_number From Customer
Regards,
------------------
Serge
Software Developer
[email protected]
[email protected]
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.
I think it's SELECT DISTINCTROW, not just DISTINCT....??
DISTINCTROW is going to omit the details he (?) wants. You need to give more details on what you're trying to do.