Table1 code Status WN007 NotPaid WN008 NotPaid Table2 Billno Code 2001 WN007 2003 WN009
Table1 Code Status WN007 Paid WN008 NotPaid
Update Table1 Set Status = 'Paid' Where code in (select code from table2)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)