Update query

[Anon]

I have a problem concerning a updatequery (using mysql).

In mysql you can make a update query:

UPDATE Custumers SET Custumer_Name = 'Hahaa; WHERE Custumer_id = '10';

My problem is how can u use more than one table in de update statement f.i in Access:

UPDATE Custumers INNER JOIN Relations ON Custumers.Custumers_id = Relations.Custumers_id SET Custumers.Name= "Hahaa"
WHERE Relations.Relation_id ="56";

I can't find a solution .....

[Anon]

I would do a select query with the multiple tables first to find the primary key of the table you want to update, then do the update.

I don't think it is possible to do an update like that in Access. If it were Oracle you could do a subquery in the where clause.

[Anon]

In this case i have more than one record that i would like to update.
I really hope there is a way to do this in a single query, I almost can't believe this is not possible ...

[Anon]

Can't be done in Mysql with one query.

[Anon]

Thank you for your answer. I think I am going to report it to mySql as a bug ! 😉