Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT t1.cl_otraslineas, t1.identificacion, t3.tl_telefono, t5.cod_dane
- FROM
- cl_clientes t1 LEFT JOIN dr_direccion t2 ON(t1.cl_id = t2.cl_id)
- LEFT JOIN tl_telefono t3 ON(t1.cl_id = t2.cl_id)
- LEFT JOIN ci_ciudad t4 ON(t2.ci_id = t4.ci_id)
- LEFT JOIN ps_pais t6 ON(t6.ps_id = t4.ps_id)
- LEFT JOIN ciudades_dane t5 ON(t6.ps_nombre = t5.departamento)
- LEFT JOIN ON(t4.ci_nombre = t5.ciudad)
- WHERE t1.identificacion = '2868833'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement