Unable to use CREATE VIEW SKI_CUST1 AS

[Arif_Tamboli]

CREATE VIEW SKI_CUST1 AS
SELECT FirstName,
LastName,
Street,
Citi,
State,
Zipcode,
InvoiceNumber
FROM CUSTOMER JOIN INVOICE
USING (CustomerID) ;

While running Query gettig an error massage "Syntax error in CREATE TABLE statement" and curser shows/holds "VIEW"

CREATE VIEW SKI_CUST1 AS

 

[Joe4]

This looks like the same kind of question you asked over here: https://www.mrexcel.com/forum/microsoft-access/1069137-access-2016-sql-post5134987.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

You have replies over there that you never responded to. Please continue in that original thread.