Avatar of jspc
jspc
Flag for Australia asked on

SQL Script to Remove Data from Two Joined Tables

Hello

I have two Tables in my SQL Database

Products
PSuppliers

I want to remove data from both tables.

They are linked as follows:
Products.UniqueID = PSuppliers.ProductID

Are you able to help me write a script to remove data from the Products table where the Products.Code = ‘AAA’ and in the related data PSuppliers Table where they are linked by PSuppliers.ProductID?
SQLMicrosoft SQL Server

Avatar of undefined
Last Comment
Shaun Kline

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Shaun Kline

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23