Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, Need some help with the following MS-SQL My Guitar Shop question: Write a DELETE statement that deletes rows from the Products table for products

Hello, Need some help with the following MS-SQL "My Guitar Shop" question:

Write a DELETE statement that deletes rows from the Products table for products that do not have any orders for that Product.

DELETE FROM Products WHERE Orders IS NULL;

This does NOT work as the Orders column does not exist

image text in transcribed

dboAddresses dboAdministrators E dbo.categories dboCustomers dbo.OrderItems Columns ItemlD (PK, int, not null) OrderlD (FK, int, null) ProductID (FK, int, null ltemPrice (money, not null) DiscountAmount (money, not null) Quantity (int, not null) Keys Constraints Triggers Indexes Statistics dbo.Orders Columns OrderlD (PK, int, not null) CustomerlD (FK, int, null) OrderDate (datetime, not null) ShipAmount (money, not null) TaxAmount (money, not null) ShipDate (datetime, null) ShipAddressID (int, not null) CardType (varchar(50), not null) CardNumber (char(16), not null) CardExpires (char(7), not null) BillingAddressID (int, not null) E

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 22nd European Conference Adbis 2018 Budapest Hungary September 2 5 2018 Proceedings Lncs 11019

Authors: Andras Benczur ,Bernhard Thalheim ,Tomas Horvath

1st Edition

3319983970, 978-3319983974

More Books

Students also viewed these Databases questions