$q->from('Table1 t1')->addFrom('Table2 t2')->where('t1.id = t2.id')
$q->from('Table1 t1')->innerJoin('Table2 t2')
とか。