CodeIgniter Forums
join querys - 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: join querys (/showthread.php?tid=57410)



join querys - El Forum - 03-12-2013

[eluser]Unknown[/eluser]
:question:




i have an issue for joining three tables i'm confused with left and right joins and also the inner join ..
i have three tables namely new_item_adding,friends and userdetails
new_item_adding has the following fields:`id`, `user_id`, `category`, `Create_Item_Link`, `size`, `Est_Value`, `Brand`, `style`, `Purchase_Date`, `buy_it_now`, `regi_input_size`, `Handbag`, `Dress`, `Accessories`, `add_date`, `group`, `status`.
friends has the following fields:`id`, `requestFrom`, `requestTo`, `status`, `createdBy`, `createdDate`
and userdetails has the following fields:`id`, `username`, `fname`, `lname`, `password`, `passconf`, `email`, `photo`, `address`, `city`, `state`, `zip`, `cc`, `exp`, `cvv`, `dob`, `size`, `favBrand`, `myStyle`, `aboutMe`



i need to access the details of userdetails who are my friends and the new items they have added in new_item_adding table


join querys - El Forum - 03-13-2013

[eluser]TheFuzzy0ne[/eluser]
Welcome to the CodeIgniter forums!

Google is your friend. No point asking us to reinvent the wheel. We have better things to do. Smile

http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php