Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. DELETE * FROM t1 JOIN t2 WHERE t1.c1=0 OR (t1.c2=t2.c1 AND t2.c3=3)
  2.  
  3. DELETE FROM t1 WHERE t1.c1=0 OR EXISTS (SELECT 1 FROM t2 WHERE t1.c2=t2.c1 AND t2.c3=3)
  4.  
  5. DELETE * FROM t1 JOIN t2 WHERE t1.c1=0 OR t1.c2=t2.c1 AND t2.c3=3
  6.  
  7. DELETE FROM t1 WHERE t1.id IN (SELECT id
  8. FROM t1
  9. INNER JOIN t2 u on t1.id_externo = t1.id
  10. WHERE COLOCA TU CONDICION AQUI)
  11.  
  12. DELETE FROM t1 WHERE t1.id IN (CONSULTA) OR t1.id IN (CONSULTA)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement