SIMULATION
You have a view named Person.vAdditionalContactInfo that uses data from a table named Customers. The Customers table was created by running the following Transact-SQL statement:
You need to create a query that returns the first and last names of a customer from the view. If the CustomerID column does not have a value defined, the following message must be added to the query result: “Customer ID Does Not Exist.” Construct the query using the following quidelines:
Do not use aliases for column or table names.
Display the columns in the same order as they are defined in the Customers table.
Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within code that has been provided as well as below it.
Use the ‘Check Syntax’ button to verify your work. Any syntax or spelling errors will be reported by line and character position.
A. Please review the explanation part for this answer
