Sunjen
Member since Apr 17, 2011
- Profile: /members/8172-sunjen.htm
- Comments: 1
Recent Blog Comments By Sunjen
-
Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)
Posted on Apr 17, 2011 at 10:04 PM
Great post. I tried a: DELETE FROM tablex WHERE id NOT IN (SELECT id FROM tabley LEFT OUTER JOIN...) Good thing: It works Bad thing : It is SLLLOWWW when your table has a lot of records. I might try an Index or something else..... read more »