Viewing 3 posts - 1 through 3 (of 3 total)
Solved with a CTE.
With AcctTrav as (Select * from Accounts where Jdx = 180)Merge into AcctTrav aUsing TTN5563 tOn t.TaxID = a.TaxID
February 28, 2022 at 9:24 pm
#3990728
That didn't work I removed the "and jdx = 180" from the "When not matched by Source" portion and it deleted rows that were not 180.
February 28, 2022 at 9:08 pm
#3990722
I think I figured it out.
Merge into Accounts aUsing TTN5563 tOn t.TaxID = a.TaxID And a.jdx = 180
February 28, 2022 at 8:55 pm
#3990719