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~ -----Original Message----- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 10:42 AM To: Elly Wisata; [EMAIL PROTECTED] Subject: Re: query
I don't understand your question. And if I don't understand it, there are probably a lot of others who don't understand it either. Rhino ----- Original Message ----- From: "Elly Wisata" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 03, 2004 10:20 PM Subject: query > Hi *, > > How to query records that most of the fields are the same value? Izit > possible? > > Thanks in advance > > > > ~Elle~ > > -- 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]
