Home
Join

3 Replies

  • Nevermind, I managed to figure it out.

    Anyone that had the same question I had, use the below and just add in your table info:

    BEGIN TRAN

    DELETE a FROM [table name] a
    INNER JOIN [your etl table] b on b.QueuedIDs = a.QueuedIDs

    --COMMIT TRAN

    Spice (2) flagReport
    Was this post helpful? thumb_up thumb_down
  • Yes, delete using a join is a common thing yet surprisingly there are lots who do not know about it.

    Good to hear you got it worked out.

    Spice (1) flagReport
    Was this post helpful? thumb_up thumb_down
  • Alec6638 wrote:

    Yes, delete using a join is a common thing yet surprisingly there are lots who do not know about it.

    Good to hear you got it worked out.

    Agreed. I started with Oracle and always used WHERE EXISTS. That's what I continue to use with SQL Server.

    Alec6638

    Was this post helpful? thumb_up thumb_down

Read these next...