Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- clientes.idClientes,
- clientes.nome,
- clientes.bloqueado,
- planosclientes.idPlanos,
- planos.nome,
- enderecos.bairro,
- enderecos.cidade
- FROM
- planosclientes INNER JOIN clientes ON planosclientes.idClientes = clientes.idClientes AND
- planosclientes INNER JOIN planos ON planosclientes.idPlanos = planos.idPlanos AND
- planosclientes INNER JOIN enderecos ON planosclientes.idPlanosClientes = enderecos.idPlanosClientes
- WHERE
- clientes.bloqueado = 's' AND
- enderecos.tipoEndereco = 'i'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement