join

Query q = posDao.createNativeQuery(builder.toString());
q.setParameter("tenantId", tenantId);
q.setParameter("ouId", ouId);
q.setParameter("docDateFrom", docDateFrom);
q.setParameter("docDateTo", docDateTo);
q.setParameter("limit", limit);
q.setParameter("offset", offset);
q.setParameter("docTypePos", PosIntegrationConstants.DOCUMENT_SALES_RETAIL_SHOP);
q.setParameter("docTypePosShop", PosIntegrationConstants.DOCUMENT_SALES_RETAIL_SHOP_IN_SHOP);