Advertisement
Guest User

Untitled

a guest
Dec 5th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. DELETE FROM Vertriebsdatenbank1.[Firma], Vertriebsdatenbank1.[Tel], Vertriebsdatenbank1.[Email]
  2.  
  3. WHERE (((Vertriebsdatenbank1.[Firma]) IN (SELECT [Firma] FROM [Vertriebsdatenbank1] AS Tmp GROUP BY [Firma] HAVING COUNT(*)>1 )))
  4. AND Vertriebsdatenbank1.[Tel] IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement