CodeIgniter Forums
update table with join. - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: update table with join. (/showthread.php?tid=48397)



update table with join. - El Forum - 01-15-2012

[eluser]Unknown[/eluser]
hi guys, i just want to ask how to update a table join with other tables.

lets say, i have have this table with fields...
_____________________
table1_id
table_name
table2_id //(the foreign key)
_____________________

and another table with this....
___________________________
table2_id
table2_characteristic
___________________________

how can i update table2_characteristic by joining the two tables?
or is it possible?
sorry guys i just having a not so good time coding so please do help me...
thank you in advance. Smile