Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Montreal, Canada

    Exclamation Unanswered: Delete statement using a join plz help

    well i have 2 table one name detcom and another entcom stored in DB1 the key for both to join on is lets say A, B, C . I need to check if there are records based on the key A, B, C of both table where C EQUALS to '80_300_113' and if there are delete them and then grab data from another
    database named DB2 on same server (same instance) wich contains the same tables entcom and detcom and insert all the data from those tables into the same tables in DB1 based on the key and where C = '80_300_113'

    PLZ help

  2. #2
    Join Date
    Dec 2002
    Sunny Florida
    Do I understand it right that you basically want to replace data in one DB with data from another database?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts