I'm trying to update 3 fields from the RANKS table into the RATES table, linking IDs as the unique identifier.
FOR SOME REASON, the result of running the query doesn't give the message: "ARE YOU SURE YOU WANT TO UPDATE..." instead it spits out a table (shown on the right) and doesn't have any fields.
If I flip the code to feed RATES into RANKS, it works perfectly...but that doesn't help me.
The RANKS table is a global table fed by an ODBC connection. That shouldn't affect it, but I'm totally clueless and have been trying to figure this out FOR WEEKS!!!!!!!!!!!!!!!!
PLEASE PLEASE PLEASE HELP ME, anyone!
UPDATE dbo_Bid_Rates
RIGHT JOIN dbo_bid_Ranks ON dbo_Bid_Rates.ID = dbo_bid_Ranks.ID
SET dbo_Bid_Rates.RATE_RANK = [dbo_bid_Rank].[RANK],
dbo_Bid_Rates.LC_CARR1 = [dbo_bid_Rank].[LC_CARR1],
dbo_Bid_Rates.LC_Carr2 = [dbo_bid_Rank].[LC_CARR2];
picture: https://docs.google.com/leaf?id=0B3M...3Yzg3&hl=en_US