Skip to content
Advertisement

How do I update multiple columns with a subquery in a single statement?

I am attempting to update a temp table from a source table:

Unfortunately it complains

Advertisement

Answer

After much trial and error I pooled some help at work and we came up with this:

Which sybase seems to accept.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement