AV1611 Posted May 31, 2006 Share Posted May 31, 2006 Will this work?"delete from lbrypermInner Join lbryperm ON keithlyimport.TPN = lbryperm.TEK_PART_NUMBER"I want to delete all records from lbryperm that have a match on the JOINOr,how do I delete all record from lbryperm where lbryperm.TEK_PART_NUMBER = keithlyimport.TPN?I got it......delete from lbryperm where TEK_PART_NUMBER in (select distinct TPN from keithlyimport) Quote Link to comment https://forums.phpfreaks.com/topic/10869-is-this-valid/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.