update and joins

[mrsbean]

I always have trouble with joins ... especially when I'm using an older version of MySQL which does not support Inner Joins. The following query does not work. Can anyone help me fix it and/or direct me to a tutorial where I learn this? I usually use the query builder in MS Access when I have a difficult query to write, and it doesn't always work in MySQL:

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

MrsBean

 

[guelphdad]

all versions of mysql support inner joins. if you mean older versions don't support multiple table updates that is a different thing entirely. which version of mysql are you using?

 

[r937]

I usually use the query builder in MS Access when I have a difficult query to write, and it doesn't always work in MySQL

that's because Access and MySQL use different versions of sql

r937.com | rudy.ca