Advertisement
jotazetaec

Untitled

Jun 28th, 2023
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. select tc.nombre as congreso, tp.tema , tce.descripcion, tcl.nombre_area from esq_conv_2020.tbl_ponencias tp
  2. join esq_conv_2020.tbl_congreso_linea tcl on tcl.idregistro = tp.id_congreso_linea
  3. join esq_conv_2020.tbl_congreso tc on tc.idregistro = tcl.id_congreso
  4. join esq_conv_2020.tbl_convencion_estado tce on tce.idregistro = tp.id_estado
  5. where tc.id_convencion = 5 and tcl.nombre_area = 'POSGRADO'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement