[TYPO3-dev] Making an inner join with pi_query_exec?

[Brian Bendtsen]

HI

Im new at extension programming and Im trying something like this:

$conf['where'] = "AND table1.value = 1 AND table2.value = 2"
$conf['query'] = "FROM [table1] INNER JOIN [table2] ON table1.id = 
table2.foreignkeyid"

$this->pi_exec_query('table1', $addWhere = $conf['where'], $query = 
$conf['query'])

- but im not getting the results I want, actually I think the $query 
with the join is not working.

What is wrong with this?

By the way, the method description says that PID selecting clauses are 
bybassed, what does that mean?

/Brian Bendtsen