Advertisement
Guest User

Timesheet ANP - Contratos e Atividades

a guest
Apr 18th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.38 KB | None | 0 0
  1. select *
  2. from cliente
  3. where id = '000119';
  4.  
  5. select *
  6. from customers
  7. where codcli = '000119';
  8.  
  9.  
  10. select *
  11. from colaborador
  12. where (
  13.     nome like '%REBECCA%TORRES%'
  14.     or nome like '%ALBERTO%JUNIOR%'
  15. )
  16. and deleted_at is null;
  17.  
  18. select *
  19. from atividades
  20. where idCustomer in (6, 149)
  21. and (
  22.     owner_matricula = '002588'
  23.     or owner_matricula = '002589'
  24. )
  25. and deleted_at is null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement