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) Link to comment https://forums.phpfreaks.com/topic/10869-is-this-valid/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.