-- UPDATE dbo.tblRSPBooking -- SET CancelDate = vwPartnerTransactions.TransactionDate, -- IsCanceled = vwPartnerTransactions.IsCancel select * FROM SERVER1.VSAPI.dbo.vwPartnerTransactions WHERE PartnerId = 1006 AND IsCancel = 1 AND TransactionDate >= @LastCancel AND tblRSPBooking.MWTransactionID = ReversalTransactionID
I need to do a select on this one.
I get The multi-part identifier "tblRSPBooking.MWTransactionID" could not be bound.
on the AND tblRSPBooking.MWTransactionID = ReversalTransactionID
Is it safe to assume that in order to do a select i need to join MWTransactionID and ReversalTransactionID
select ......etc from SERVER1.VSAPI.dbo.vwPartnerTransactions T join tblRSPBooking R on T.MWTransactionID = R.ReversalTransactionID