Community Member Profile
Sunjen
Member since Apr 17, 2011
- Profile: /members/8172-Sunjen.htm
- Comments: 1
- Points: 11
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 »
