[CDBI] Trying to model query in Class::DBI
perrin at elem.com
Wed Jan 4 18:30:45 GMT 2006
On Wed, 2006-01-04 at 18:07 +0000, Alan Griffiths wrote:
> I'm trying to model the following query in Class::DBI: -
> SELECT c.name
> FROM carrier c, carrier_presence cp, location l
> WHERE c.carrier_id = cp.carrier_id
> AND cp.location_id = l.location_id
> AND l.country_id = 1;
> I thought that DeepAbstractSearch would do the trick, but after
> reading the documentation it seems not. I'm sure that this is
> possible, but I'm just missing something.
Is there a reason you don't want to use the SQL you already wrote? Have
you read this?
More information about the ClassDBI