Description: ------------ in MDB_QueryTool when class build the select, the function don't build with an inner/outer join, why?

can you further explain the issue you're experiencing? I didn't understand what you mean exactly...

I'm trying to use inner join on a select $obj->setJoin(...); // here I dont have problem but in $res = $obj->get/getAll/getCol...(...);// result unexpected $obj->getQueryString();//get the select query without inner Join

You are using ibase, right? Then the join implementation triggered an "invalid token" error, because the joined table columns were aliased as "_tablename_colname" but it looks like ibase aliases can't start with a "_" character. With ibase, now they are aliased as "t_tablename_colname" (notice the leading "t_"). Can you try the latest CVS version, please?

the function getJoin don't return inner/outer join.

I've added some testcases and everything works as expected. Last time I forgot to commit the changes to MDB_QueryTool (only to DB_QueryTool), sorry. Can you try the latest CVS version, please?

By chance, have you tried the latest CVS version? Is it working for you too?

don't working all rigth with me $qt = &new MDB_QueryTool($dsn); $qt->setTable('bug'); $qt->setJoin('bug_host' ,'fk_host = id_host' ,'inner'); $qt->getAll(); var_dump($qt->getQueryString()); //in this line the query returned is without inner join

aha! Now I understand what you mean. INNER JOINs were not supported (we had 'default' joins), I just added them. What about now?

Now that all right. thank's

This bug has been fixed in CVS. In case this was a documentation problem, the fix will show up at the end of next Sunday (CET) on pear.php.net. In case this was a pear.php.net website problem, the change will show up on the website in short time. Thank you for the report, and for helping us make PEAR better.