I want to change dealerid to 3 for every dealer with a contract id = 3. I'm getting an error near '=' ? I don't know what's wrong? Thanks for help!
select * from contract where contractid = 15 set dealerid = 3
Printable View
I want to change dealerid to 3 for every dealer with a contract id = 3. I'm getting an error near '=' ? I don't know what's wrong? Thanks for help!
select * from contract where contractid = 15 set dealerid = 3
your SQL clauses are out of order.. it should read
UPDATE contract
set dealerid = 3
where contractid = 15
-tg