[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
