Prueba asi:
Código SQL:
Ver originalSELECT h.hora,h.marca,h.codoptima,h.target,P.CODOPTIMA,O.CODIGO,
p.hora,p.peso,p.vaso,p.fecha,o.linea,o.tubo
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 = 'L15N'
AND o.tubo LIKE 'A%'
AND p.fecha >= '2010-06-16 10:00' AND p.fecha <= '2010-06-16 10:30'
AND p.hora='10:00 - 10:30'
AND h.hora='10:00 - 10:30'