Advertisement
Iv555

Untitled

Jun 4th, 2022
264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.28 KB | None | 0 0
  1. DELETE FROM ClientsCigars
  2. WHERE ClientId IN (SELECT Id FROM Clients
  3. WHERE AddressId IN (SELECT Id FROM Addresses
  4. WHERE Country LIKE 'C%'))
  5.  
  6. DELETE FROM Clients
  7. WHERE AddressId IN (SELECT Id FROM Addresses
  8. WHERE Country LIKE 'C%')
  9.  
  10. DELETE FROM Addresses
  11. WHERE Country LIKE 'C%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement