note
trwww
<p>DBIx::Class certainly has what you are asking for with <a href="http://search.cpan.org/~arodland/DBIx-Class-0.08196/lib/DBIx/Class/Relationship.pm#has_one">has_one</a>, and combining <a href="http://search.cpan.org/~arodland/DBIx-Class-0.08196/lib/DBIx/Class/Manual/Joining.pod#Subset_of_related_fields
">Subset_of_related_fields</a> and <a href="http://search.cpan.org/~arodland/DBIx-Class-0.08196/lib/DBIx/Class/Manual/Joining.pod#Incomplete_related_objects">Incomplete_related_objects</a>.</p>
<p>I'd put together an example for you but its all right there.</p>
<p>Also, you didn't mention you'd be doing updates, as mentioned elsewhere I believe a view would make the most sense.</p>
968506
968544