[TYPO3-dev] Joining table with Typo3 ?

[Yannick]

Allo,

Can you tell me if my code is right please ?

--------------
$where = sprintf("p.uid=f.programme AND f.uid=c.fiche_id AND 
                                        f.uid = %d", 
                                        $this->piVars[f]
                                );
$sql = $db->exec_SELECTquery('f.nom_fiche, f.contenu,
p.nom','tx_mccfiche_fiches as f, tx_mccfiche_programme as
p,tx_mccfiche_contenu as c ',$where);

$InfosFiche = $db->sql_fetch_assoc($sql);
<...

--------

I have one record in this request, but I don't know do "joining table" with
Typo3.

Thank

Yannick