ShockUK
asked on
SQL Set Multiple Set Query
Hello,
I'm using the following SET query which works perfectly
UPDATE [Data] SET [Action]="Query" WHERE [Acc Num]=230061;
But now I want to change it so it updates 4 fields in one go, tried the following but it doesn't
work, any ideas?
UPDATE [Data] SET [Action]="Query" AND [Comments]="test" AND [Promise Payments]="0.00" AND [Date]=date() WHERE [AccNum]=230061;
Thanks
I'm using the following SET query which works perfectly
UPDATE [Data] SET [Action]="Query" WHERE [Acc Num]=230061;
But now I want to change it so it updates 4 fields in one go, tried the following but it doesn't
work, any ideas?
UPDATE [Data] SET [Action]="Query" AND [Comments]="test" AND [Promise Payments]="0.00" AND [Date]=date() WHERE [AccNum]=230061;
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.