update

[mouniryoussef]

how can i update two tables in one statement update ?


thanks

 

[jbenson001]

You can't

 

[mouniryoussef]

are you sur ? someone asked me this question in an interview..@#$%^&*

thanks a lot

 

[jbenson001]

If you take a look at the syntax of the update statement you will see it allows only one table to be updated at one time. Try it, create 2 tables and try to do a set on one col in tableA and a set for a col in tabelB. You will get an error. Unless there is some sort of trick that I am not aware of, I would like to know it!!!