Hola tengo un problema con mi query la cual me da error, me dice:
Msg 107, Level 16, State 2, Line 1
The column prefix 'o' does not match with a table name or alias name used in the query.
Código SQL:
Ver originalSELECT h.hora AS hora1,h.marca,h.codoptima AS codoptimaT,h.target,h.fecha AS hfecha,P.CODOPTIMA,O.CODIGO,
p.hora,p.peso,p.vaso,p.fecha,o.linea
INTO #tmp1
FROM optimas AS o,htargets AS h
INNER JOIN pesos AS p ON o.codigo = p.codoptima
WHERE o.codigo = p.codOptima AND o.linea = 'L01N'
AND p.fecha >='20100705'
AND h.fecha >='20100705'
AND p.hora= '11:00 - 11:30' AND h.codoptima = o.codigo AND h.hora='11:00 - 11:30'
SELECT *,(SELECT COUNT(1)total FROM #tmp1) AS totality FROM #tmp1