Error "Each GROUP BY expression must contain at least one column that is not an outer reference" for valid SQL (4307754)

Chatee ahora con Soporte

Regresar

Título

Error "Each GROUP BY expression must contain at least one column that is not an outer reference" for valid SQL
Descripción

When optimizing, the following valid query prompts for bind variables when it shouldn't.
select Test_Bench.BenchName,
Test_Attributes.Name
FROM Test_Bench LEFT
JOIN Test_Session
ON PK_Test_Bench = FK_Test_Bench
LEFT JOIN Test_Suite
...
where Test_Bench.PK_Test_Bench = '10'
group by Test_Bench.BenchName, Test_Attributes.Name
ORDER BY Test_Attributes.Name
After clicking OK, the following error occurs:
"Each GROUP BY expression must contain at least one column that is not an outer reference"

Debe iniciar sesión

Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.

Contenido recomendado

Producto(s):: SQL Optimizer for SQL Server
10.1.2, 10.1.1, 10.1, 10.0.3, 10.0.1

Historial del artículo:: Creado el: 8/12/2016
Última actualización: 5/7/2023