Jump to content


Is this valid?

  • Please log in to reply
No replies to this topic

#1 AV1611

  • Members
  • PipPipPip
  • Advanced Member
  • 997 posts

Posted 31 May 2006 - 03:28 PM

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)

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users