Link to home
Start Free TrialLog in
Avatar of ShockUK
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
ASKER CERTIFIED SOLUTION
Avatar of chaitu chaitu
chaitu chaitu
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial