Bug #3842

Inner/outter join

Details

Request #3842	Inner/outter join
Submitted	2005-03-16 13:38 UTC
From	fabio at bs2 dot com dot br
Assigned	quipo
Status	Closed
Package	MDB_QueryTool
PHP Version	Irrelevant
Roadmaps	(Not assigned)

Comments

[2005-03-16 13:38 UTC] fabio at bs2 dot com dot br

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

[2005-03-18 11:39 UTC] fabio at bs2 dot com dot br

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

[2005-03-18 20:19 UTC] fabio at bs2 dot com dot br

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

[2005-04-22 14:10 UTC] fabio at bs2 dot com dot br

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

[2005-04-22 14:51 UTC] fabio at bs2 dot com dot br

Now that all right.

thank's