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




>>I'm getting the error "The objects "MOC" and "MOC" in the FROM clause have the same exposed names. Use correlation names to distinguish them."
>>
>>I don't know what this means.
>>
>>Here's my query:
>>
>>

>>SELECT	RQ_MOCNUMBER, 
>>		RQ_MOCREFNO, 
>>		RQ_IMKEY, 
>>		RQ_DATE_REQ, 
>>		RQ_DATE_PROM, 
>>		SUM(CASE WHEN sf.BookedQty IS NULL THEN 0 ELSE
>>			CASE WHEN sf.RQ_DATE_REQ >= RQ_DATE_REQ AND sf.RQ_DATE_REQ <= 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 MOC ON MOC.MOC_OHNUMBER = RQ.RQ_MOCNUMBER
>>	INNER JOIN MOC ON 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*'
>>	ORDER BY RQ.RQ_MOCNUMBER, RQ.RQ_MOCREFNO, RQ.RQ_IMKEY, RQ.RQ_DATE_REQ, RQ.RQ_DATE_PROM
>>

>
>Kevin,
>
>This is where the problem is:
>

>INNER JOIN MOC ON OH.OH_NUMBER = MOC.MOC_OHNUMBER
>	INNER JOIN MOC ON MOC.MOC_OHNUMBER = RQ.RQ_MOCNUMBER
>	INNER JOIN MOC ON MOC.MOC_REF_NO = RQ.RQ_MOCREFNO
>

>
>You can not join the same table under the same alias multiple times.
>
>You need to use different aliases if you want to self join the same table, e.g.
>

>INNER JOIN MOC ON OH.OH_NUMBER = MOC.MOC_OHNUMBER
>	INNER JOIN MOC MOC1 ON MOC1.MOC_OHNUMBER = RQ.RQ_MOCNUMBER
>	INNER JOIN MOC MOC2 ON MOC2.MOC_REF_NO = RQ.RQ_MOCREFNO
>

>
>Also, it looks like you didn't really want to join MOC table multiple times, you wanted to join based on multiple fields, right?
>

>INNER JOIN MOC ON OH.OH_NUMBER = MOC.MOC_OHNUMBER
>AND  MOC.MOC_OHNUMBER = RQ.RQ_MOCNUMBER
>AND MOC.MOC_REF_NO = RQ.RQ_MOCREFNO