Update + Exists doesn't seem to work

Description

Don't know if this is me or not but this query doesn't seem to work with the many to many relationship between reservation and customer:

Query query;
query = manager.createQuery("UPDATE Reservation res " +
"SET res.amountPaid = (res.amountPaid + 10) " +
"WHERE EXISTS (" +
"SELECT c FROM res.customers c " +
"where c.firstName = 'Bill' and " +
"c.lastName='Burke')");
query.executeUpdate();

Environment

None

Status

Assignee

Steve Ebersole

Reporter

Bill Burke

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure