Advertisement
Guest User

Untitled

a guest
Nov 26th, 2014
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT * FROM pendencia, cliente
  2. LEFT JOIN servico ON pendencia.id_pendencia = servico.id_pendencia
  3. LEFT JOIN cidade ON cliente.id_cidade = cidade.id_cidade
  4. WHERE cliente.id_cliente = pendencia.id_cliente AND servico.ativo = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement