| Noel da Costa 2007-05-11, 7:01 pm |
| Hi all,
Quick quizzle about DB_DataObject Joins...
Can I create a join on the same table?
For example:
$m =& DB_DataObject::factory('person');
$m->selectAdd();
$m->selectAdd('distinct email');
$f =& DB_DataObject::factory('person');
$m->joinAdd($f);
.... so I'm trying to eliminate duplicate emails and then still return
all the fields from that table.
Ideas?
Thanks,
Noel
Noel da Costa
Lead Developer
Magnet Harlequin
T: 01895 432400
M: 07879 427940
F: 01895 432444
E: noel.dacosta@magharl.co.uk
W: http://www.magharl.co.uk
This e-mail is intended solely for the addressees named above and any
other
use is prohibited. Access to this email by anyone else is
unauthorised. It
may contain confidential information. If you have received this e-
mail in
error, please contact the sender by return e-mail. We do not accept
legal
responsibility for the contents of this message if it has reached you
via
the internet. Any opinions expressed are those of the author and are not
necessarily endorsed by the company. Recipients are advised to apply
their
own virus check to this message and all incoming e-mail on delivery.
|