UPDATE...WHERE...
Posted: Thu Sep 26, 2002 12:27 pm
I have two tables t1 and t2, and I have a text(description). At t1 I have the code and at t2 the description of the code and it's foreign key.
I need to update fields in t1. Is it possible with this code?
FK = FOREIGN KEY
Am I clear?
I need to update fields in t1. Is it possible with this code?
Code: Select all
UPDATE t1, t2 SET t1.field1 = value WHERE t1.ID = t2.FK AND t2.text = descriptionAm I clear?