ormlite 多表联合查询

QueryBuilder shopBrandQueryBuilder = shopBrandDao.queryBuilder();
QueryBuilder shopQueryBuilder = shopDao.queryBuilder();

Where shopBrandWhere = shopBrandQueryBuilder.where();
shopBrandWhere .eq(ShopBrand.SHOP_NO, shopNo);

Where shopWhere = shopQueryBuilder.where();
shopWhere
.like(Shop.SHOP_CODE, "%" + serch + "%")
.or()
.like(Shop.SHOP_LNAME, "%" + serch + "%");

QueryBuilder resultQueryBuilder =          
shopBrandQueryBuilder
.join(shopQueryBuilder);
shopBrands=resultQueryBuilder.query();