jspc
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.