1 from DesignActivity
2 select e.id,e.name from DesignActivity as e
3 select e.id,h.originator from DesignActivity as e
left join e.designCommissionActivity as h
4 select e.id,e.name from DesignActivity as e,
Project as h
where e.project=h
5 select p.id from Project p
left join p.currentProjectDetail pd
left join p.regionType
left join pd.budget,
SetupActivity sa