SHARE
TWEET

Untitled

a guest Jul 23rd, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE view [dbo].[Familiar] as
  2. select
  3. fam_familiar,
  4. fam_materno,
  5. fam_paterno,
  6. fam_enferme,
  7. fam_escolaridad,
  8. fam_especialidad,
  9. Par_ECEdoCivFam.PAR_DESCRIP1 as fam_idedocivil,
  10. fam_fecnac,
  11. fam_lugarnac,
  12. Par_PSNacFam.PAR_DESCRIP1 as fam_idnacionalidad,
  13. fam_nombre,
  14. fam_ocupacion,
  15. fam_parentesco,
  16. Par_SXSexoFam.PAR_DESCRIP1 as fam_idsexo,
  17. fam_telemensa,
  18. fam_vive
  19. from dhu_familiar,
  20. pnc_parametr Par_ECEdoCivFam,pnc_parametr Par_PSNacFam,pnc_parametr Par_SXSexoFam
  21. where
  22. Par_ECEdoCivFam.PAR_TIPOPARA ='EC' and
  23. Par_ECEdoCivFam.PAR_IDENPARA =* fam_idedocivil and
  24. Par_PSNacFam.PAR_TIPOPARA ='PS' and
  25. Par_PSNacFam.PAR_IDENPARA =* fam_idnacionalidad and
  26. Par_SXSexoFam.PAR_TIPOPARA ='SX' and
  27. Par_SXSexoFam.PAR_IDENPARA =* fam_idsexo
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top