//view tasks by role
SELECT a.roles_name,b.menus_nomb, c.mtask_desc, c.mtask_action  FROM gen_troles a, gen_tmenus b, gen_tmtask c, gen_trtask d WHERE d.roles_codi=a.roles_codi and d.menus_codi=b.menus_codi and d.mtask_codi=c.mtask_codi

CREATE VIEW gen_vrtask as SELECT d.rtask_codi,a.roles_codi,a.roles_name,b.menus_codi,b.menus_nomb,b.menus_mod,b.menus_con, c.mtask_codi, c.mtask_desc, c.mtask_action FROM gen_troles a, gen_tmenus b, gen_tmtask c, gen_trtask d WHERE d.roles_codi=a.roles_codi and d.menus_codi=b.menus_codi and d.mtask_codi=c.mtask_codi;

//view ciudades 
CREATE VIEW gen_vciuds as SELECT a.ciud_codi,a.ciud_dane, a.ciud_nomb,b.deps_codi, b.deps_nomb, c.pais_codi, c.pais_iso2, c.pais_iso3, c.pais_nomb FROM gen_tciud as a, gen_tdeps as b, gen_tpais as c WHERE b.pais_codi=c.pais_codi and a.deps_codi=b.deps_codi;


//view vinculaciones

CREATE VIEW gen_vvipers AS SELECT b.vipe_codi, a.vinc_codi, a.vinc_nomb, b.pers_codi FROM gen_tvinc as a, gen_tvipe b where a.vinc_codi=b.vinc_codi;