✅ Why wont these SQL queries work?

Creating a userview - this works.

CREATE VIEW GoodCustomer
AS SELECT CustomerID, CustomerName,
MemberCategory,CountryCode
FROM Customers
WHERE MemberCategory IN (‘A’,’B’)

CREATE VIEW GoodCustomer
AS SELECT CustomerID, CustomerName,
MemberCategory,CountryCode
FROM Customers
WHERE MemberCategory IN (‘A’,’B’)

Update userview - doesnt work

UPDATE GoodCustomer
SET MemberCategory = ‘C’
WHERE CustomerID = 1000

UPDATE GoodCustomer
SET MemberCategory = ‘C’
WHERE CustomerID = 1000

Insert userview: - doesnt work

INSERT INTO GoodCustomer (CustomerID,
MemberCategory, CountryCode)
VALUES ( ‘5000',’C’, ‘USA' )

INSERT INTO GoodCustomer (CustomerID,
MemberCategory, CountryCode)
VALUES ( ‘5000',’C’, ‘USA' )

C#•4y ago•

4 replies

Creating a userview - this works.

CREATE VIEW GoodCustomer
AS SELECT CustomerID, CustomerName,
MemberCategory,CountryCode
FROM Customers
WHERE MemberCategory IN (‘A’,’B’)

CREATE VIEW GoodCustomer
AS SELECT CustomerID, CustomerName,
MemberCategory,CountryCode
FROM Customers
WHERE MemberCategory IN (‘A’,’B’)

Update userview - doesnt work

UPDATE GoodCustomer
SET MemberCategory = ‘C’
WHERE CustomerID = 1000

UPDATE GoodCustomer
SET MemberCategory = ‘C’
WHERE CustomerID = 1000

Insert userview: - doesnt work

INSERT INTO GoodCustomer (CustomerID,
MemberCategory, CountryCode)
VALUES ( ‘5000',’C’, ‘USA' )

INSERT INTO GoodCustomer (CustomerID,
MemberCategory, CountryCode)
VALUES ( ‘5000',’C’, ‘USA' )