vocabulary table [php] vid name description 2 vegitable this is vegitable [/php] node_revision table [php] nid vid uid title body teaser 21 21 1 mouse program test test [/php] term_data table [php] tid vid name 5 2 ladies finger 6 2 onion 7 2 beetroot 8 2 ladies finger2 9 2 onion2 10 2 beetroot2 [/php] term_node table [php] nid tid 18 4 21 5 21 7 21 8 19 10 20 10 21 10 19 11 [/php] Hi friends the above is my table can any one tell the sql query for that ????? id related all content must display with that query... any great idea,,,plz i welcome :D