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();