I’m getting error in this below line,
CREATE VIEW reorder_view
AS
SELECT a.S_CODE AS S_CODE,
a.CODE AS CODE,
a.PRCT_TYPE AS PRCT_TYPE,
b.VENR_CODE AS VENR_CODE,
b.MATERAL_CODE AS MATERAL_CODE,
b.ORDER_LEVEL AS ORDER_LEVEL,
c.SUPPL_NAME AS SUPPL_NAME,
sum(a.QTY) AS TOTAL_QTY
FROM ((storage a
join supplier_items b)
join supplier_info c)
WHERE b.MATERAL_CODE = a.S_CODE
AND b.VENDR_CODE = c.VENDR_CODE
GROUP BY a.S_CODE,
c.VENDR_CODE
HAVING TOTAL_QTY <= b.ORDER_LEVEL ;
error msg:
‘CREATE VIEW’ must be the first statement in a query batch.,
Incorrect syntax near ‘)