I entered the following SQL statements using Access SQL view, but Access says there is an error in the CREATE statement and highlights the VIEW command withing the text. Does anyone know why?
CREATE VIEW Housewares AS
SELECT PartNum, Description, OnHand, Price
FROM Part
WHERE Class = 'NW'
;
Note: Table Part is opened prior to entering these lines.
CREATE VIEW Housewares AS
SELECT PartNum, Description, OnHand, Price
FROM Part
WHERE Class = 'NW'
;
Note: Table Part is opened prior to entering these lines.