View the Exhibit and examine the structure of the CUSTOMERS table.
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have
the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:
INSERT INTO new_customers (cust_id, cust_name, cust_city)
VALUES(SELECT cust_id,cust_first_name’ ‘cust_last_name,cust_city
FROM customers
WHERE cust_id > 23004);
The INSERT statement fails when executed.
What could be the reason?
A.
The VALUES clause cannot be used in an INSERT with a subquery.
B.
Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
C.
The WHERE clause cannot be used in a subquery embedded in an INSERT statement.
D.
The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
Insert into new_customers (select ….) is correct statement
so values should not come here
Using sub-selects example:
INSERT INTO suppliers
(supplier_id, supplier_name)
SELECT account_no, name
FROM customers
WHERE city = ‘Newark’;
So no, you cannot have the VALUES clause in the above statement.
A
A.
The VALUES clause cannot be used in an INSERT with a subquery.
if you want to make insert in the table from sub query can you make it like
INSERT INTO new_customers (cust_id, cust_name, cust_city)
(SELECT cust_id,cust_first_name’ ‘cust_last_name,cust_city
FROM customers
WHERE cust_id > 23004);