Syntax error in UPDATE statement

Well that is a very vague question...

What sort of database are we talking about here?

Do you want to do it all in one database call or in multiple calls?

Is there a relationship between the tables you want to do all this on?

The more specific you can be about your problem the more likely you are to get a helpful response.

And www.asp101.com/samples has some good, short database examples.