table_1 id pid nid ----------------------- 1 6 0 2 0 5 table_2 (referer -> pid) id title body ----------------------- 1 title1 body_text1 2 title2 body_text2 3 title3 body_text3 4 title4 body_text4 5 title5 body_text5 6 title6 body_text6 7 title7 body_text7
table_3 (referer -> nid) id ntitle nbody -------------------------- 1 ntitle1 nbody_text1 2 ntitle2 nbody_text2 3 ntitle3 nbody_text3 4 ntitle4 nbody_text4 5 ntitle5 nbody_text5 6 ntitle6 nbody_text6 7 ntitle7 nbody_text7 I want to get values table_2 and table_3 according to table_1. As a result, it must be as below. id title body ------------------------ 6 title6 body_text6 5 ntitle5 nbody_text5 What would be the query? Thanks for your help. -- Ali Deniz EREN ali.deniz.e...@gmail.com
