Jump to content

Archived

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

AV1611

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


Or,

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.