select * from
schet
left join error schet_error on schet.id_pak=schet_error.id_pak and schet_error.id_sluch is null and schet_error.id_usl is null
left join sluch on sluch.id_pak=schet.id_pak
left join error sluch_error on sluch.id_pak=sluch_error.id_pak and sluch.id_sluch=sluch_error.id_sluch and sluch_error.id_usl is null
left join usl on usl.id_sluch=sluch.id_sluch and usl.id_pak=sluch.id_pak
left join error usl_error on usl.id_pak=usl_error.id_pak and usl.id_sluch=usl_error.id_sluch and usl.id_usl=usl_error.id_usl
left join intox on intox.id_pak=usl.id_pak and intox.id_sluch=usl.id_sluch and intox.id_usl=usl.id_usl
left join expert on expert.id_pak=usl.id_pak and expert.id_sluch=usl.id_sluch and expert.id_usl=usl.id_usl
--where [всякие условия]
order by schet.id_pak,sluch.id_pak,sluch.id_sluch,usl.id_pak,usl.id_sluch,usl.id_usl,intox.id_pak,intox.id_sluch,intox.id_usl,expert.id_pak,expert.id_sluch,expert.id_usl

        try {
            Class classname = Schet.class;
            CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
            CriteriaQuery<Object> criteriaQuery = criteriaBuilder.createQuery();

            Root<Schet> schet = criteriaQuery.from(Schet.class);
            Root<Sluch> sluch = criteriaQuery.from(Sluch.class);
            Root<Usl> usl = criteriaQuery.from(Usl.class);



            //CriteriaQuery<Object> select = criteriaQuery.multiselect(schet, sluch, usl);
            List sel=new ArrayList();
            sel.add(schet);
            sel.add(sluch);
            sel.add(usl);
            CriteriaQuery<Object> select = criteriaQuery.select(schet.join("sluchList", JoinType.LEFT).join("uslList", JoinType.LEFT)).distinct(true);


            TypedQuery<Object> typedQuery = em.createQuery(select);
            Object some_ret = typedQuery.getResultList();

            String gg = "";


        } catch (Exception e) {
            String er = e.getMessage();
            String gh = "";
        }

select поля сущности from таблица where (id=?)

SELECT t0.[поля],t2.[поля],t1.[поля]
FROM MEDFIN.SCHET t0
LEFT OUTER JOIN MEDFIN.SLUCH t4 ON (t4.ID_PAK = t0.ID_PAK)
LEFT OUTER JOIN MEDFIN.USL t3 ON ((t3.ID_PAK = t4.ID_PAK) AND (t3.ID_SLUCH = t4.ID_SLUCH))
,
USL t2, SLUCH t1 WHERE (t3.SKIND = '5')