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)
Is this valid?
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users