I only have 1 table for this job. Your example is using 2 table. ~Elle~
-----Original Message----- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 11:08 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: FW: query 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]