Selecting data from SQL tables.

[TosaInu]

Hello,

What's the syntax to get data from a table by using data from another? It's done in PERL and it always confused me there, using ->{' '} ->{''}

Example editing the postbit template:

<div>$vbphrase[usergroup]: $post[usergroupid]</div>

But I want to display the title for the group, not the ID. It collected data from table users and now information from table usergroups is required.

<div>$vbphrase[usergroup]: $post[usergroupid->[title]]</div> does not work. What's the correct syntax?