SugarCRM: MySQL Query Update Contacts
Query 1 Adds Vendedor = 1 To All Contacts that are Joined to a Manufacturer UPDATE contacts INNER JOIN a26_proveedor_contacts_c ON contacts.id = a26_proveedor_contacts_c.a26_proveedor_contactscontacts_idb INNER JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c SET contacts_cstm.vendedor_c = 1 Query 2 […]