firefly2k8
Registered User.
- Local time
- Yesterday, 16:56
- Joined
- Nov 18, 2010
- Messages
- 48
Here is the logic:
if field-a and field-b are in table-y then field-c is set to alpha
here is my SQL
UPDATE TableX
INNER JOIN TableY
ON (TableX.FieldA = TableY.Currency AND TableX.FieldB=TableY.Currency)
SET TableX.FieldC = 'alpha';
But this doesn't update when it should. Where am I going wrong
if field-a and field-b are in table-y then field-c is set to alpha
here is my SQL
UPDATE TableX
INNER JOIN TableY
ON (TableX.FieldA = TableY.Currency AND TableX.FieldB=TableY.Currency)
SET TableX.FieldC = 'alpha';
But this doesn't update when it should. Where am I going wrong
