First, can you share the object mappings between the two entities/tables?
Second, which type is sectorName? I'm assuming String, but need to know if sectorName is case-sensitive. If not, try using Restrictions.ilike() instead of Restrictions.like().
Originally posted by Narsimha Reddy: I have search functionality in my application. Search fields are not belongs to main table.Ids are avaible in main table , corresponding values are avalidable in related table. I tried using Criterion