Advertisement
jotazetaec

Untitled

Dec 10th, 2024
9
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. select tp.idregistro ,codigo ,tema , resumen, palabra_clave
  2. from esq_conv_2020.tbl_ponencias tp
  3. join esq_conv_2020.tbl_congreso_linea tcl on tcl.idregistro = tp.id_congreso_linea
  4. join esq_conv_2020.tbl_congreso tc on tc.idregistro = tcl.id_congreso
  5. where tc.id_convencion = 9
  6. and tp.id_estado in (61,63,64)
  7. and tp.codigo not in('CCIUTM-REG-ADM')
  8. and tc.idregistro not in (128)
  9. order by tc.nombre, tcl.nombre_area , tp.tema
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement