Update with WHERE from multiple tables

Here are some table definitions: CREATE TABLE x10_device_types ( device_typename VARCHAR(20) NOT NULL, respondstoalloff enum('TRUE','FALSE') NOT NULL, respondstoalllightson enum('TRUE','FALSE') NOT NULL, respondstoalllightsoff enum('TRUE','FALSE') NOT NULL, respondstoallunitsoff enum('T

Update with WHERE from multiple tables

Here are some table definitions: CREATE TABLE x10_device_types ( device_typename VARCHAR(20) NOT NULL, respondstoalloff enum('TRUE','FALSE') NOT NULL, respondstoalllightson enum('TRUE','FALSE') NOT NULL, respondstoalllightsoff enum('TRUE','FALSE') NOT NULL, respondstoallunitsoff enum('T