Hi,
I'm a little confused... :ermm:
your first and your second post both describe a rather large update statement.
However, your third post is regarding an insert statement and in the last post you're talking about a completely different, but more simple update statement.
I would have expected data definition and sample data for the first case rather than two new issues leaving the first one unanswered at the same time...