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