Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.logracompl, e.id,
- (SELECT b.nome FROM bairros b WHERE b.id = e.bairro_id) AS bairro,
- (SELECT c.nome FROM cidades c WHERE c.id = e.cidade_id) AS cidade,
- (SELECT uf.uf FROM estados uf WHERE uf.id = e.uf_cod) AS estado,
- e.cep
- FROM enderecos e
- WHERE e.cep = '69450-000';
- SELECT c.nome AS cidade,
- (SELECT uf.uf FROM estados uf WHERE uf.id = c.estado_cod) AS estado,
- c.cep
- FROM cidades c
- WHERE c.cep = '69450-000'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement