Jump to content


This topic is now archived and is closed to further replies.


Is this valid?

Recommended Posts

Will this work?

"delete from lbryperm
Inner Join lbryperm ON keithlyimport.TPN = lbryperm.TEK_PART_NUMBER"

I want to delete all records from lbryperm that have a match on the JOIN


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)

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.