Click here to Skip to main content
15,667,736 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How can I update records in table but I am using table just like this:(this code has error)
UPDATE payment AS p FROM income AS i, details AS d 
WHERE = AND d.department = i.department
Updated 10-Jan-11 0:50am
Sandeep Mewara 10-Jan-11 6:51am    
Avoid using CAPITALS - it is considered shouting...

1 solution

By SQL Update statement you can't update a table. you can just update rows.

See SQL Update[^] for more.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900