/*UPDATE billing_data dest
     INNER JOIN organization src ON src.ClientID = dest.vendor_id_ma
     SET dest.vendor_id = src.id;
     
     
     SELECT DISTINCT vendor_id, vendor_id_ma FROM billing_data
     ORDER BY vendor_id_ma;*/
     
     
     
     
      
     
     
          
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'A-COPI'; #2860
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'AXIS';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'BUDGET';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'CSA-VT';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'CanonME';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'KMBS';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'NA1927';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'OSV';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'RICOH';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'ROTECH';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'SPC';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'SYMVT';
     #SELECT * FROM billing_data WHERE vendor_id_ma = 'XEROXCopie';