Advertisement
staszhalba

Удаляет несуществующие номера телефонов

Dec 10th, 2020
1,743
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. DELETE b_crm_field_multi
  2. FROM b_crm_contact
  3. RIGHT OUTER JOIN b_crm_field_multi
  4. ON b_crm_field_multi.element_id = b_crm_contact.id
  5. WHERE b_crm_field_multi.entity_id = 'CONTACT' AND b_crm_contact.id IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement