Cita:
si alguien sabe algo se los encargo la duda la tengo donde esta el "left", ya que por lo visto no lo puedo poner así y debido a las comparaciones no puedo sacar todos los registros.... SELECT distinct rcs.`FOLIO`, CONCAT(so.`nombre(s)`, so.`a paterno`, so.`a materno`) as nombre, so.componente,so.`CONCEPTO`, so.`apoyo solicitado (solicitado)` as monto_solicitado, so.`apoyo (comprometido)` as monto_comprometido, so.`Nivel de Atencion de solicitud` as dictame_suri, cs.`status`, s.ORGANIZACION, CONCAT(a.`nombre`,a.`ap`,a.`am`) as autoriza, c.prioridad FROM
rel_compromiso_solictud as rcs,
solicitudes as so,
compromiso as c,
solicitante as s,
autoriza as a,
left cat_status as cs
where rcs.folio = so.`Folio Estatal` and rcs.idcompromiso = c.idcompromiso and c.idautoriza = a.idautoriza and c.IDSOLICITANTE = s.IDSOLICITANTE and cs.idstatus = rcs.`NIVEL_ATENCION`
UNION
SELECT distinct rcs.`FOLIO`, CONCAT(so.`nombre(s)`, so.`a paterno`, so.`a materno`) as nombre, so.componente,so.`CONCEPTO`, so.`apoyo solicitado (solicitado)` as monto_solicitado, so.`apoyo (comprometido)` as monto_comprometido, so.`Nivel de Atencion de solicitud` as dictame_suri, cs.`status`, s.ORGANIZACION, CONCAT(a.`nombre`,a.`ap`,a.`am`) as autoriza, c.prioridad FROM
rel_compromiso_solictud as rcs,
solicitudes_hom as so,
compromiso as c,
solicitante as s,
autoriza as a,
left cat_status as cs
where rcs.folio = so.`Folio Estatal` and rcs.idcompromiso = c.idcompromiso and c.idautoriza = a.idautoriza and c.IDSOLICITANTE = s.IDSOLICITANTE and cs.idstatus = rcs.`NIVEL_ATENCION`
rel_compromiso_solictud as rcs,
solicitudes as so,
compromiso as c,
solicitante as s,
autoriza as a,
left cat_status as cs
where rcs.folio = so.`Folio Estatal` and rcs.idcompromiso = c.idcompromiso and c.idautoriza = a.idautoriza and c.IDSOLICITANTE = s.IDSOLICITANTE and cs.idstatus = rcs.`NIVEL_ATENCION`
UNION
SELECT distinct rcs.`FOLIO`, CONCAT(so.`nombre(s)`, so.`a paterno`, so.`a materno`) as nombre, so.componente,so.`CONCEPTO`, so.`apoyo solicitado (solicitado)` as monto_solicitado, so.`apoyo (comprometido)` as monto_comprometido, so.`Nivel de Atencion de solicitud` as dictame_suri, cs.`status`, s.ORGANIZACION, CONCAT(a.`nombre`,a.`ap`,a.`am`) as autoriza, c.prioridad FROM
rel_compromiso_solictud as rcs,
solicitudes_hom as so,
compromiso as c,
solicitante as s,
autoriza as a,
left cat_status as cs
where rcs.folio = so.`Folio Estatal` and rcs.idcompromiso = c.idcompromiso and c.idautoriza = a.idautoriza and c.IDSOLICITANTE = s.IDSOLICITANTE and cs.idstatus = rcs.`NIVEL_ATENCION`