Problem Duplicate With Category

[virak]

Dear Support,I have problem with my website when i added LG(sub category) in to Mobile Phone Center(Category), it's appear duplicate.Before Add: Apple [4] BlackBerry [2] HTC [1] Motorola [5] Nokia [12] Samsung [1] Sony Ericsson [1]Duplicate After Added LG(Subcategory)Apple [4] BlackBerry [2] HTC [1] LG [2] Motorola [5] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Nokia [12] Samsung [3] Samsung [3] Samsung [3] Sony Ericsson [1]Please visit http://shop.orkun2u.com/supplier/product.p...CategoryID=1672for you reference.I try to edit sql statement again and again, but still appear duplicate,Would anyone can help me to write up the SQL statement to Group the Duplicate(Sub Category)Your help is appreciated.Many thanks and Regards,Virak

[justsomeguy]

You're going to need to post the code you're using if people are going to be able to help.