Advertisement
pipook

datos

Oct 13th, 2012
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.43 KB | None | 0 0
  1. SELECT t1.cl_otraslineas, t1.identificacion, t3.tl_telefono, t5.cod_dane
  2. FROM
  3.     cl_clientes t1 LEFT JOIN dr_direccion t2 ON(t1.cl_id = t2.cl_id)
  4.     LEFT JOIN tl_telefono t3 ON(t1.cl_id = t2.cl_id)
  5.     LEFT JOIN ci_ciudad t4 ON(t2.ci_id = t4.ci_id)
  6.     LEFT JOIN ps_pais t6 ON(t6.ps_id = t4.ps_id)
  7.     LEFT JOIN ciudades_dane t5 ON(t6.ps_nombre = t5.departamento)
  8.     LEFT JOIN ON(t4.ci_nombre = t5.ciudad)
  9. WHERE t1.identificacion = '2868833'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement