Thread: SQL Query

I'm wondering if anyone has any ideas of what to change in my query here. Currently it doesn't update any rows. Any ideas?

Code:

UPDATE gc SET gc.Balance = agc.S6CRBL - o.OrderTotal FROM GiftCard gc INNER JOIN @APLUSGiftCards agc ON gc.SerialNumber = agc.S6CRNO LEFT JOIN Orders o ON gc.SerialNumber = o.CouponCode WHERE gc.SerialNumber IN (SELECT SerialNumber FROM @WebGiftCards) AND o.CouponType = @CouponType AND ((o.PaymentMethod = 'PURCHASEORDER' AND o.TransactionState = 'PENDING') OR (o.PaymentMethod = 'CREDITCARD' AND o.TransactionState = 'AUTHORIZED'))

Do I need to loop to do the update instead?

Where is the APLUSGiftCards table coming from? I don't recall seeing that in the out of the box code and I'm not having much luck finding it.

Sorry about that. This is part of a sproc. @APLUSGiftCards and @WebGiftCards are temp tables that I load with data on exec. @CouponType = 2

It's not updating because your WHERE and JOINs are not returning any rows to be affected. The only way we can work it out is, if you supply the structure of your temp tables and some example data.