Jayant Das

Recent Blog Comments By Jayant Das

• Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)

  Posted on Jan 21, 2013 at 5:38 AM

  Please ignore my earliar comments on this as MY Colleague kidding with me. Sorry once again Jayant Dass... read more »

• Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

  Posted on Jan 21, 2013 at 5:11 AM

  Hello All, any one of you tested below query ? DELETE g FROM guest g INNER JOIN profile p ON g.id = p.userID ; Given query is not functioning properly , it has been delteting all data in both case g.id = p.userID or g.id <> p.userID Thanks & Regards Jayant Kumar Das :):):) Cheers... read more »