SQL Syntax - Delete Records based on another tables data
Posted on 2010-09-08
I have the following 2 tables:
Columns: ProductType, ReleaseDate, CustomerType
Columns: ProductType, DateFrom, DateTo, CustomerType
How could I create an SQL DELETE statement to delete records from tblProducts based on records that match within tblDormantProducts?...
with tblProducts.ReleaseDate, this needs to match between tblDormantProducts.DateFrom and tblDormantProducts.DateTo.