+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Join function of Database (/showthread.php?tid=48976)
Join function of Database - El Forum - 02-03-2012
[eluser]Desmond[/eluser]
<Solved, thanks everyone>
Hello everyone, just a simple question but I can't solve it for long. Please help. Thank you so much.
I have two tables in database
Table_A : Shop_id | Shop_name,
3 | ABC shop
5 | DEF Shop
Table_B : Shop_id | Price
2 | 10
5 | 15
How can I get the Shop_name (DEF Shops) form table_A if I have input Price =15?
can I use the join function to achieve this?
Thanks again;-)