That's true. I'm only using one table. It is called a self-join. You alias the tables in the FROM clause, and then can refer to them as two separate tables in your WHERE clause. See the part of the FROM clause where I say "as"? That's aliasing the table. A temporary renaming, if you will. Trust me, it will work with one table. :)
You might want to read the section of the MySQL manual on Selects as well as Joins. You might want to learn SQL. :) j----- k----- On Wednesday 03 March 2004 07:35 pm, Elly Wisata wrote: > 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] -- 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]
