joinn

SELECT A.region_customer_id, A. region_id, B.region_code,
        B.region_name, A.customer_id, C.partner_code,
        C.partner_name, A,version
FROM RegionCustomer.TABLE_NAME A
INNER JOIN Region.TABLE_NAME B ON A.region_id = B.region__id
INNER JOIN City.TABLE_NAME C ON A.city_id = C.city_id
INNER JOIN Partner.TABLE_NAME D ON A.customer_id = C.partner_id
WHERE A.tenant_id = :tenantId
     .addIfNotEquals( GeneralConstans.NULL_REF_VALUE_FOR_LONG, regionId, " AND A.region_id =  "+regionId   )
     .addIfNotEmpty( customerCodeName,   " AND (  " + CriteriaHelper.likeExperssionIgnoreCase( customerCodeName, "A.partner_code" )
          + " OR "
          + CriteriaHelper.likeExperssionIgnoreCase( customerCodeName, "A.partner_name" )
          + " ) " )