public List<tableAObject> getValuesBySomeIdList(List<Long> someOtherIdList) {
       List<tableAObject> list = Collections.emptyList();
       
       StringBuffer query = new StringBuffer("select tableA ");
       query.append("from tableAObject tableA, tableBObject tableB ");
       query.append("where tableA.id = tableB.id ");
       query.append("and tableA.someOtherNumVal in (:listParameter)" );
       
       list = getSession().createQuery(query.toString())
          .setParameterList("listParameter, someOtherIdList).list();
       
       return list;
    }