Skip to content

Instantly share code, notes, and snippets.

@duard

duard/update-blu-fix-checklist-template-in-workOrder.sql

Created July 30, 2020 07:44
Show Gist options
  • Save duard/1e28cc7a8f22d79ac7ff7c6f42958d2c to your computer and use it in GitHub Desktop.
Save duard/1e28cc7a8f22d79ac7ff7c6f42958d2c to your computer and use it in GitHub Desktop.
Download ZIP
update-blu-fix-checklist-template-in-workOrder
Raw
update-blu-fix-checklist-template-in-workOrder.sql
update
ordens_trabalho
set
id_modelo_checklist = modelos_checklist.id_modelo_checklist
from
detalhes_servico,
modelos_checklist
where
detalhes_servico.id_detalhe_servico = ordens_trabalho.id_detalhe_servico
and modelos_checklist.id_detalhe_servico = detalhes_servico.id_detalhe_servico
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment