How to Join Two Tables

[mhmbox]

I would like to compose a query this way:

$query = $orm->table();
              ->where('foo_id', $foo['id'])
              ->like('foo_name', '%DP') 
              ->fetch();

it's possible?