i'm doing query on mysql subquery in select clause , got error: #2014 - commands out of sync; can't run command haven't been able solve it. can me please?
select e.iddocumento, e.cvedistrito, d.stct_nom, e.cvejuzgado, j.ctju_descr, e.numdocumento, e.idramodocumento, r.descripcion....., (select pd.nombre partedocumento pd pd.iddocumento = e.iddocumento) nombreactor documentos e inner join ctramo r on ( r.idramo = e.idramodocumento ) inner join ctestado edo on ( edo.cveestado = e.cveestado ) inner join ctdisjud d on (d.stct_num = e.cvedistrito) inner join ctjuzgad j on (j.ctju_munic = e.cvedistrito , j.ctju_juzga = e.cvejuzgado) left join ctmediopresentacion m on ( m.idmediopresentacion = e.idmediopresentacion ) e.idtipodocumento =1 , e.esrecibido =1
this query. did same query in sql server , works!
i not 100% sure, think can not use table from
clause in subselect inside of select
. why not join table instead of subselect:
select e.iddocumento, e.cvedistrito, d.stct_nom, e.cvejuzgado, j.ctju_descr, e.numdocumento, e.idramodocumento, r.descripcion....., pd.nombrenombreactor documentos e inner join ctramo r on ( r.idramo = e.idramodocumento ) inner join ctestado edo on ( edo.cveestado = e.cveestado ) inner join ctdisjud d on (d.stct_num = e.cvedistrito) inner join ctjuzgad j on (j.ctju_munic = e.cvedistrito , j.ctju_juzga = e.cvejuzgado) left join ctmediopresentacion m on ( m.idmediopresentacion = e.idmediopresentacion ) left join partedocumento pd on pd.iddocumento = e.iddocumento e.idtipodocumento =1 , e.esrecibido =1
Comments
Post a Comment