### Question:
PartyDAO extends ListBasedDAO<NamedList<T>, T, IdNamePair> { public List<IdNamePair> findAllWithMember(Long characterId) { String tables = TABLE + ", " + AbstractPartyMembershipDAO.TABLE; String[] columns = getTable().union(memberDao.getTable(), PARTY_ID, AbstractPartyMembershipDAO.PARTY_ID); String partyMatchSelector = String.format("%s.%s=%s.%s", TABLE, PARTY_ID, AbstractPartyMembershipDAO.TABLE, AbstractPartyMembershipDAO.PARTY_ID); String characterSelector = AbstractPartyMembershipDAO.CHARACTER_ID + "=" + characterId; String selector = andSelectors(partyMatchSelector, characterSelector); return findFiltered(tables, columns, selector, null); } PartyDAO(Context context, OwnedGenericDAO<Long, ?, T> itemDao); List<IdNamePair> findAllWithMember(Long characterId);  }### Answer:
@Test public void findAllWithMember() throws DataAccessException { IdNamePair party2 = new IdNamePair("party 2"); IdNamePair party3 = new IdNamePair("party 3"); IdNamePair party4 = new IdNamePair("party 4"); partyDao.add(party2); partyDao.add(party3); partyDao.add(party4); memberDao.add(party2.getId(), member1a); memberDao.add(party4.getId(), member1a); assertThat(partyDao.findAllWithMember(member1a.getId()), containsInAnyOrder(party1.idNamePair(), party2, party4)); }