Oh, so what you're looking for a a find duplicates query (as MS Access calls it). That's something like this (I'm rusty, so you might have to debug).
SELECT fname, lname, etc FROM my_table as table1, my_table as table2 WHERE table1.fname = table2.fname AND table1.lname = table2.lname ...etc... AND table1.customer_id <> table2.customer_id That should give you duplicate rows, or something close to it. Hope that helps. j----- k----- On Wednesday 03 March 2004 06:51 pm, Elly Wisata wrote: > In 1 table, I probably have double records or triple records with the same > value for several fields. > Example : table customer with field customer_id, address, DOB, Services > I need to know that customer data in my table have more than 1 record for 1 > customer. So he/she has more then 1 customer_id. > I need to query the double record, not the DISTINCT one. > > ~Elle~ -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... .... ..- .- -.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]