Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE view [dbo].[Familiar] as
- select
- fam_familiar,
- fam_materno,
- fam_paterno,
- fam_enferme,
- fam_escolaridad,
- fam_especialidad,
- Par_ECEdoCivFam.PAR_DESCRIP1 as fam_idedocivil,
- fam_fecnac,
- fam_lugarnac,
- Par_PSNacFam.PAR_DESCRIP1 as fam_idnacionalidad,
- fam_nombre,
- fam_ocupacion,
- fam_parentesco,
- Par_SXSexoFam.PAR_DESCRIP1 as fam_idsexo,
- fam_telemensa,
- fam_vive
- from dhu_familiar,
- pnc_parametr Par_ECEdoCivFam,pnc_parametr Par_PSNacFam,pnc_parametr Par_SXSexoFam
- where
- Par_ECEdoCivFam.PAR_TIPOPARA ='EC' and
- Par_ECEdoCivFam.PAR_IDENPARA =* fam_idedocivil and
- Par_PSNacFam.PAR_TIPOPARA ='PS' and
- Par_PSNacFam.PAR_IDENPARA =* fam_idnacionalidad and
- Par_SXSexoFam.PAR_TIPOPARA ='SX' and
- Par_SXSexoFam.PAR_IDENPARA =* fam_idsexo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement