mysql "view" for editing thread.title & post.pagetext

[Rik Brown]

I've been trying to create my first mysql "view" in order to edit thread titles while viewing the corresponding pagetext to the first post in the thread. I'm using a mysql frontend, Navicat, to display the view but the underlying "view" syntax appears to be the problem.

Here's the basic syntax for the view:

select `thread`.`title` AS `title`,
`post`.`pagetext` AS `post_pagetext`,
`post`.`username` AS `post_username`,
`post`.`postid` AS `post_postid`,
`post`.`threadid` AS `post_threadid`,
`thread`.`forumid` AS `thread_forumid`,
`thread`.`dateline` AS `thread_dateline`
from (`post` join `thread`)
where (`post`.`threadid` = `thread`.`threadid`)
group by `thread`.`threadid`
having ((`thread`.`forumid` = _utf8'505')
and (`thread`.`dateline` < _utf8'1228090965'))
order by `thread`.`title`

I do get the correct view that I'm trying to get. However, I cannot edit the thread titles as I always get an error message advising that the "target table ..... of the update is not updateable."

Does anyone know how to change the view code above to make the target table "updateable" or perhaps has working code they can cut and paste here?

Thanks. -- Rik