• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
join querys


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

Welcome to the CodeIgniter forums!

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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.