lineasinvestigacion

SELECT
  esq_ceac_investigacion.tbl_inv_lineas_investigacion.idregistro,
  esq_ceac_investigacion.tbl_inv_lineas_investigacion.linea_investigacion AS sublinea,
  esq_ceac_investigacion.tbl_inv_lineas_investigacion.id_linea_padre,
  tbl_inv_lineas_investigacion1.linea_investigacion,
  tbl_inv_lineas_investigacion1.id_area_conocimiento,
  esq_catalogos.tipo.nombre AS area_conocimiento
FROM
  esq_ceac_investigacion.tbl_inv_lineas_investigacion
  INNER JOIN esq_ceac_investigacion.tbl_inv_lineas_investigacion tbl_inv_lineas_investigacion1 ON (esq_ceac_investigacion.tbl_inv_lineas_investigacion.id_linea_padre = tbl_inv_lineas_investigacion1.idregistro)
  INNER JOIN esq_catalogos.tipo ON (tbl_inv_lineas_investigacion1.id_area_conocimiento = esq_catalogos.tipo.idtipo)