I have been trying to run a command from the SQL view
I'm getting a syntax error

CREATE VIEW TopLevelCust AS
SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit
FROM Customer
WHERE (((Customer.[CreditLimit])>=10000));

Recommended Answers

Don't think you need the [ ... ] around CreditLimit

Jump to Post

All 3 Replies

Don't think you need the [ ... ] around CreditLimit

try this query

CREATE VIEW TopLevelCust AS
SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit
FROM Customer
WHERE CreditLimit >= 10000;

Did you figure this out? I have to do the same thing and I'm getting the same error! I'm stuck!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.