Nodes and vocabulary database relationship Drupal 6

Tables required 

1-term_node

2-term_data

3-vocabulary

$query5="SELECT * FROM term_node a, term_data b WHERE a.nid='$row[nid]' AND a.tid=b.tid  ";

$res5=mysql_query($query5);

while($row5=mysql_fetch_array($res5))

{

        $query6="SELECT * FROM vocabulary WHERE `vid`='$row5[vid]'";

$res6=mysql_query($query6);

$row6=mysql_fetch_array($res6);

 echo $row6['name'];

 echo ":";

 echo $row5['name'];

}