update query and joins

[mrsbean]

I always have trouble with this. I want to perform an update on table1 based on information which is obtained from table2. Here's what I tried. It doesn't work. Can anyone tell me how to do it correctly and/or a tutorial which will help me understand it better? I'm using MySQL 3.23.58 so I can't use inner joins.

UPDATE tblmembership LEFT JOIN tblduespaid ON tblmembership.wsuaaID = tblduespaid.wsuaaID SET tblmembership.userGroup = 1
WHERE (((tblduespaid.Year)=2006)) OR (((tblduespaid.Year)=2007));

MrsBean

 

[Vragabond]

There is no php question here. You would be better served in the MySQL forum (forum436).