Hey All
Trying to add another Where clause
WHERE BBG_TradeID is not used in table tblBBG already
I can't do indexes, caz blank values are fine
Code:UPDATE tblCONCORD INNER JOIN tblBBG ON (tblBBG.BBG_ISIN=tblCONCORD.CONCORD_ISIN) AND (tblBBG.BBG_Price=tblCONCORD.Price) SET tblBBG.BBG_TradeID = tblCONCORD.Trade_ID WHERE BBG_TradeID ='';