Jump to content


Photo

Is this valid?


  • Please log in to reply
No replies to this topic

#1 AV1611

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


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)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users