Giacomo P. Thu Dec 16 15:48:13 -0500 2010

Subject: add a column in a join

Hi all,
It is quite complex to explain what I need and why ... but I will try...
I have a JOIN between 2 tables "A" and "B" and I do it by this syntax:

$join = 'JOIN B ON ...'
$res = A::all('join' => $join);

In this way I get ALL the column of the A table in $res but I need to have also a column from the B table in $res... is it possible?


Kien La Tue Dec 21 18:25:26 -0500 2010

Yes, just use the "select" option

http://www.phpactiverecord.org/projects/main/wiki/Finders#select

(1-1/1)