Complex update query

[MikeGarvin]

Hi

Saw your query does not work under mysql. I get the following error:

You can't specify target table 'story_category' for update in FROM clause.

story_category is the table name in colHdg.

Any idea? Thanks.

[szlamany]

Sorry - I don't use MySQL.

The syntax I showed was for MS SQL.

[MikeGarvin]

Thanks. I tried on Access and MS SQL and it works fine. MySQL does not though. Thanks anyway.