+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: What is the process for updating data from a 3-table join in a database? (/showthread.php?tid=86828)
What is the process for updating data from a 3-table join in a database? - JackToncatridr - 02-19-2023
What is the process for updating data from a 3-table join in a database? What is the flow for updating data from a 3-table join?
The tables are as follows:
User Table
Table 1
id_user
name
password
Room Table
Table 2
id_room
name_room
status_room
price
Rev Table Joined from User Table and Room Table
Table 3
id_rev
id_room
id_user
facility
RE: What is the process for updating data from a 3-table join in a database? - InsiteFX - 02-20-2023
This should get you started.
MySQLTUTORIAL -> MySQL INNER JOIN