Mine

$player = $db->select(     array(          'zone_6.kills',           'zone_6.deaths',          'account.squad',     ),     array(          'zone_6',          'account' => array('account.id' => 'zone_6.playerid'),     ),     array(          'account.name' => 'Insertnamehere'     ));