mysql - 命令不同步；你现在不能运行这个

Question

我正在使用 SELECT 子句中的子查询对 mysql 进行查询，但收到此错误:#2014 - 命令不同步；你现在不能运行这个命令我还没能解决它。你能帮我一下吗？

SELECT e.IdDocumento, e.CveDistrito, d.STCT_NOM, e.CveJuzgado, j.CTJU_DESCR, e.NumDocumento, e.IdRamoDocumento, r.Descripcion....., (SELECT pd.nombre FROM ParteDocumento AS pd WHERE pd.IdDocumento = e.IdDocumento) AS NombreActor  
FROM Documentos AS e 
INNER JOIN CtRamo AS r ON ( r.IdRamo = e.IdRamoDocumento ) 
INNER JOIN CtEstado AS edo ON ( edo.CveEstado = e.CveEstado ) 
INNER JOIN CTDISJUD AS d ON (d.STCT_NUM = e.CveDistrito) 
INNER JOIN CTJUZGAD AS j ON (j.CTJU_MUNIC = e.CveDistrito AND j.CTJU_JUZGA = e.CveJuzgado) 
LEFT JOIN CtMedioPresentacion AS m ON ( m.IdMedioPresentacion = e.IdMedioPresentacion ) 
WHERE e.IdTipoDocumento =1 AND e.EsRecibido =1

这是我的查询。我在 SQL Server 中执行了相同的查询，它有效!

Answer 1

我不是 100% 确定，但我认为您不能在 select 内部的子选择中使用来自 from 子句的表。但为什么不简单地加入表而不是子选择:

SELECT e.IdDocumento, e.CveDistrito, d.STCT_NOM, e.CveJuzgado, j.CTJU_DESCR, e.NumDocumento, e.IdRamoDocumento, r.Descripcion....., pd.nombreNombreActor  
FROM Documentos AS e 
INNER JOIN CtRamo AS r ON ( r.IdRamo = e.IdRamoDocumento ) 
INNER JOIN CtEstado AS edo ON ( edo.CveEstado = e.CveEstado ) 
INNER JOIN CTDISJUD AS d ON (d.STCT_NUM = e.CveDistrito) 
INNER JOIN CTJUZGAD AS j ON (j.CTJU_MUNIC = e.CveDistrito AND j.CTJU_JUZGA = e.CveJuzgado) 
LEFT JOIN CtMedioPresentacion AS m ON ( m.IdMedioPresentacion = e.IdMedioPresentacion )
LEFT JOIN ParteDocumento as pd on pd.IdDocumento = e.IdDocumento
WHERE e.IdTipoDocumento =1 AND e.EsRecibido =1