I am adjunct currently teaching Intro to Databases. An example in the text books for creating new views in SQL in Access 2013 is as follows
CREATE VIEW Games AS
SELECT ItemNum, Description, OnHand, Price
FROM ITEM
WHERE Category='GME'
When I run the query it gives me a syntax error in the CREATE TABLE statement
This book seems to be full of errors and so far I have been able to figure them out; however, this time I am unsure. Thanks in advance for any help!
CREATE VIEW Games AS
SELECT ItemNum, Description, OnHand, Price
FROM ITEM
WHERE Category='GME'
When I run the query it gives me a syntax error in the CREATE TABLE statement
This book seems to be full of errors and so far I have been able to figure them out; however, this time I am unsure. Thanks in advance for any help!