Re: sql / algorithm advise is needed

From: hopehope_123 <hopehope_123_at_yahoo.com>
Date: 20 Jan 2006 03:27:18 -0800
Message-ID: <1137756438.252080.285600@z14g2000cwz.googlegroups.com>

Sorry for the less information.

I try to match customers. id1 and id2 represent customer_id . This table is the output of the data clustering program , it says

customer_id 1 and customer_id 2 are same , customer_id 1 and
customer_id 3 are same , this also means that customer_id 1 and
customer_id 3 are also same. As a results , a new customer_id can be

given for both 1,2,3 .

Same thing for the 5,7,8 .

I want to create a new table:

table_result: ( matched_id ,id )

A,1
A,2
A,3
B,5
B,7
B,8

Kind Regards,
tolga Received on Fri Jan 20 2006 - 05:27:18 CST