RakasArmas
Technical User
UPDATE [Table01] INNER JOIN [Table02] ON [Table01].ID = [Table02].ID SET [Table01].FRL = [Table02].FRL
WHERE ((([Table01].FRL) Is Null) AND (([Table02].FRL)="X"));
I'm trying to add an "X" to Table01.FRL when there is an "X" in Table02.FRL. It seems simple enough, but I am getting no update.
What am I doing wrong?
WHERE ((([Table01].FRL) Is Null) AND (([Table02].FRL)="X"));
I'm trying to add an "X" to Table01.FRL when there is an "X" in Table02.FRL. It seems simple enough, but I am getting no update.
What am I doing wrong?
