Hibernate table join issue

[salski22]

Hi all

I have problem with writing the query. My working method looks like this

public void profesionChanged(ValueChangeEvent event){


          profesion.clear();
          doctor.clear();
          
          
         String query ="select distinct p from ProfessionEntity p, DoctorEntity d where p.id=d.profesion and location_id = " + (String)event.getNewValue();
         professionList=  entityManager.createQuery(query).getResultList();
              
           for (ProfessionEntity typ: professionList) {
                item = new SelectItem(typ.getId() , typ.getProfession());
                profesion.add(item);
            }
           
  
     }

but I don't know how to write query with left join

Query from MSSQL

select p.*, d.* from ProfessionEntity p left join DoctorEntity d on p.id=d.profesion 

Please HELP

[rogermorituesta.rogermori.yahoo.com]

Hi Piotr:

Mapping Exists in the Entity Bean:

select p, d from ProfessionEntity p 
left outer join p.doctorEntity d  [optional e.g  <<with p.id is null>> ]
where .....

No mapping exists:

select p, d from ProfessionEntity p , DoctorEntity d  where p.pid = d.profession

Roger.