add join method to dao