Problema con inner join

[th3r0rn]

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:

SELECT 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
 

[iislas]

Pues el mensaje se bien claro y no tienes ningun OBJETO (TABLA) con el prefijo "o"

[th3r0rn]

Ya quedo muchas gracias

Código SQL:

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE [dbo].[monitor]
@fecha datetime,
@linea nvarchar(5),
@hora nvarchar(15) AS
BEGIN
    SET Nocount ON
 
    SELECT 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 #temporal1
    FROM optimas AS o
    INNER JOIN pesos AS p ON o.codigo = p.codoptima
    INNER JOIN htargets AS h ON o.codigo = h.codoptima
    WHERE o.linea = @linea
    AND p.fecha >= @fecha AND h.fecha >= @fecha
    AND p.hora = @hora AND h.hora = @hora
 
    SELECT *,(SELECT COUNT(1)total FROM #temporal1) AS totality FROM #temporal1
 
END