Advertisement
Guest User

Untitled

a guest
Oct 5th, 2015
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. SELECT
  2. clientes.idClientes,
  3. clientes.nome,
  4. clientes.bloqueado,
  5. planosclientes.idPlanos,
  6. planos.nome,
  7. enderecos.bairro,
  8. enderecos.cidade
  9. FROM
  10. planosclientes INNER JOIN clientes ON planosclientes.idClientes = clientes.idClientes AND
  11. planosclientes INNER JOIN planos ON planosclientes.idPlanos = planos.idPlanos AND
  12. planosclientes INNER JOIN enderecos ON planosclientes.idPlanosClientes = enderecos.idPlanosClientes
  13. WHERE
  14. clientes.bloqueado = 's' AND
  15. enderecos.tipoEndereco = 'i'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement