⬅ Back CHECK CUSTOMER AND SUPPLIER DOUBLE IN BROKERAGE PENDING REPORT.sql
use t202627


-----double
select t1.CustName f1, t2.custname as f2 from t202526.dbo.customer_master t1 inner join t202627.dbo.customer_master t2 on t1.custcode = t2.custcode where t1.CustName <> t2.custname
select t1.SuppName f1, t2.SuppName as f2 from t202526.dbo.supplier_master t1 inner join t202627.dbo.supplier_master t2 on t1.Suppcode = t2.Suppcode where t1.SuppName <> t2.SuppName