Skip to content

Instantly share code, notes, and snippets.

@suspecie
Created January 26, 2017 17:28
Show Gist options
  • Save suspecie/85592d19b439a7dec83698fea465f5d2 to your computer and use it in GitHub Desktop.
Save suspecie/85592d19b439a7dec83698fea465f5d2 to your computer and use it in GitHub Desktop.
DELETE FROM AccountingTransactionDescriptionProfile;
INSERT INTO AccountingTransactionDescriptionProfile (id_descricao_transacao_contabil, id_perfil) SELECT
id_descricao_transacao_contabil, p.id_perfil
FROM
AccountingTransactionDescription
LEFT JOIN
erp_perfil p ON 1 = 1
WHERE
p.id_perfil IN (62 , 146, 120, 117);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment