[CDBI] joining multiple tables

jvanhan jvanhan at gmail.com
Tue May 9 16:26:24 BST 2006


Hi Everyone,

I have another newby question regarding SQL statements with multiple joins
in them.

Is it possible to do something like :

class::sample->set_sql(sampleMembers => qq{
    SELECT __ALL__
      FROM __TABLE__ a, partOf b, part m, part c
     WHERE m.partID = b.groupPartID
       AND c.partID = b.subPartID
       AND m.sampleID = a.sampleID
       AND c.partName = ?
  });

I tried to define this in my sample object, but I get a

Can't locate object method "sampleMembers" via package "class::sample"

error.

Thanks a lot for your input,

Jack
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digitalcraftsmen.net/mailman/private/classdbi/attachments/20060509/96c9dfa9/attachment.html


More information about the ClassDBI mailing list