SQL Help

Question

CREATE VIEW TopLevelCust AS
SELECT CustomerNum
FROM Customer
WHERE CreditLimit >= 10000

What am I doing wrong? It should create a view table..

Answer 1

You have an AS but no alias to assign

CREATE VIEW TopLevelCust
AS viewName
SELECT CustomerNum
FROM Customer
WHERE CreditLimit >= 10000

Answer 2

I've always used mySQL. Are you making sure to create your tables first? Is there a specific error it is giving you when trying to run?

Answer 3

No but mysql workbench can, its a program you can download to work mysql

Answer 4

Jackson O’Donnell TopLevelCust is the alias. The syntax CREATE VIEW view_name AS SELECT ... FROM ... is correct IMO

Answer 5

Jackson O’Donnell I tried doing that and it did not work. I am using MS Access, is there a different non-commercial RDMS I can use?

Answer 6

Jackson O’Donnell I have a pre-made database. It pops-up with a Syntax Error on Access, and highlights the VIEW. So I’m just going to download MySQL and go from there. Can MySQL open SQL files?

Answer 7

Okay thank you Jackson O’Donnell

Answer 8

Anna I knew I was doing all of right... To bad it does not work with MS Access I really do not want to download a different DBMS :/