UPDATE `billgeneration` SET CollectedBy= ( SELECT `BillCollectionId` FROM billgeneration WHERE `PaymentId`=21 LIMIT 0,1 ) WHERE `PaymentId`=22
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)