[support] can any select query

[bharani kumar]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20080723/78912d92/attachment.htm