$p = Product->new(id => 123)->load; # row from products table in db #1
$v = $p->vendor; # related row from vendors table in db #2