MySQL Muti-table query Update

[Sparkster]

Afternoon/Evening all,

Im in need of a little MySQL help, im after a script or a MySQL command that will do the following:

I want to increment member.total field by 1 when forum.forum_id=1 and poster.post=1 where member.id = ?

I need the script to run through for each member.id (over 4000 member records)

Im unsure how to do this, ive tried a few things but without anyluck.

Any help would be great, Thanks in advance!

[tomhath]

You mention three tables: member, forum, and poster. What keys connect them?

You can probably do it all in a single update statement, but you haven't given enough information for anyone to help.

Your update might look something like this 😕

update member
set total = total + 1
from member
inner join forum
on member.??? = forum.???
inner join poster
on member.??? = poster.???
where forum.forum_id = 1
and poster.post = 1