Question 1 of 15
What needs correcting in the statement below to make it a valid UPDATE statement?

UPDATE titles SET t.ytd_sales = t.ytd_sales + s.qty FROM titles t, sales s WHERE t.title_id = s.title_id AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)





 
Exam Progress


Move on to the next question


Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home 
Copyright © Accelerated Ideas 2005-2018
All rights reserved