mysql - Commands out of sync; you can't run this now -


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