Chapter 13

--Creating the view . i'm assuming the table name so put correct name below
CREATE VIEW VendorAddress
AS
SELECT VendorID, VendorAddress1, VendorAddress2, VendorState, VendorZip, VendorCity
FROM VendorTable
GO

--select query to examine results
SELECT * FROM VendorAddress WHERE VendorID = 4

--write an UPDATE statement that changes the address so that the suite number (Ste 260) is stored in VendorAddress2 rather than in VendorAddress1