Basically I have a lot of tables linked to a main table via 2 primary keys. Lets just say that there is one main table:
Customer with primary keys custumer_type and custumer_id,
Also, there are many tables such as:
each with the same two primarykeys, all linked to the original table.
Is there away to write an UPDATE query, that will update any fields in these tables that are NOT primary keys. For instance:
UPDATE customer, customer_info, customer_this
SET customer_this.field1 = something, customer_info.field2= blah, etc.
WHERE customer_id = x AND customer_type = y AND customer_info.customer_id = customer.customer_id, etc....