[CDBI] joining multiple tables

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

_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/[email protected]
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi