>Yes, you're right.
>
>Now I', getting "The specified schema name "v_SalesForecastBookedQtyByPeriod" either does not exist or you do not have permission to use it."
>
>Here's my query now
>
>

>
>SELECT	RQ.RQ_MOCNUMBER, 
>		RQ.RQ_MOCREFNO, 
>		RQ.RQ_IMKEY, 
>		RQ.RQ_DATE_REQ, 
>		RQ.RQ_DATE_PROM, 
>		SUM(CASE WHEN sf.BookedQty IS NULL THEN 0 ELSE
>			CASE WHEN sf.RQ_DATE_REQ >= RQ.RQ_DATE_REQ AND sf.RQ_DATE_REQ <= RQ.RQ_DATE_PROM THEN sf.BookedQty ELSE 0 END
>			END) AS PeriodOrderedQty
>	FROM OH
>	INNER JOIN MOC ON OH.OH_NUMBER = MOC.MOC_OHNUMBER
>	INNER JOIN RQ ON MOC.MOC_OHNUMBER = RQ.RQ_MOCNUMBER AND 
>					 MOC.MOC_REF_NO = RQ.RQ_MOCREFNO
>	LEFT JOIN v_SalesForecastBookedQtyByDate sf ON RQ.RQ_IMKEY = sf.RQ_IMKEY
>	GROUP BY RQ.RQ_MOCNUMBER, RQ.RQ_MOCREFNO, RQ.RQ_IMKEY, RQ.RQ_DATE_REQ, RQ.RQ_DATE_PROM
>	HAVING RQ.RQ_MOCNUMBER LIKE 'FCST*'
>

>
>The view SalesForecastBookedQtyByDate is there. I don't understand why I'm getting this error
>
>
Try adding dbo. in front of the view name. Could it be that you don't have select permissions on this view (which would be quite strange)?

Right click on the view, do script select and try running it separately.