DB_Dataobject and complex joins
| From: | Hugo W. Alves | Date: | Mon, 05 Dec 2005 13:56:44 +0000 |
| Subject: | DB_Dataobject and complex joins | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-22151@lists.php.net to get a copy of this message | ||
Hi People!
How I do this using DB_DataObject functions?
select *
from table1 as a
left join table2 as b
on a.field1 = b.field1 and a.field2 = b.field2 and a.field3 = b.field3
my db.links.ini:
[table1]
field1 = table2:field1
field2 = table2:field2
field3 = table2:field3
the call:
$F = DB_DataObject::factory('table1');
$C = DB_DataObject::factory('table2');
$F->joinAdd($C);
$F->find();
the query result:
SELECT * FROM table1 INNER JOIN table2 ON table1.field1=table2.field1
Where are the others releted fields?
---------------------------------
Yahoo! doce lar. Faça do Yahoo! sua homepage.