join querys |
[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
[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. http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php |
Welcome Guest, Not a member yet? Register Sign In |