in reply to Basic Class::DBI question

Yes. See http://wiki.class-dbi.com/wiki/Using_joins.

In Section Seekers of Perl Wisdom