Select enquiry.,enquiry.user.*,enquiry.company.*,
      enquiry.issue.*,enquiry.dealer.*,enquiry.enquiryText.*
from
Enquiry enquiry
      where ( enquiry.* = input value, enquiry.issue.* = input value   )

Select enquiry
from Enquiry enquiry
where ( enquiry.* = input value, enquiry.issue.* = input value  )

@Entity
@Table(name = "ENQRY")
public class Enquiry extends AbstractEntity {
@Id
@Column(name = "CONT")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(name = "EMAILADRADD")
private String emailAddresses = "";
@Column(name = "CONFIHME")
private String Comments = "";
@Column(name = "STCONT")
private DateTime lastStatusChangeOn = new DateTime();
@Column(name = "CLANGOPTR")
private String operatorLanguage;
@Column(name = "CLANGISS")
private String issuerLanguage;
@Column(name = "CSTLCK")
@Type(type = "org.hibernate.type.YesNoType")
private boolean locked = false;
@ManyToOne
@JoinColumn(name = "USERLUPD")
private User lastUpdateByUser;
@ManyToOne
@JoinColumn(name = "USERCREAT")
private User createdByUser;
@ManyToOne
@JoinColumn(name = "USERISS")
private User issuer;
@ManyToOne
@JoinColumn(name = "USERLCK")
private User lockedByOperator;
@ManyToOne
@JoinColumn(name = "USEROPTR")
private User assignedToOperator;
@ManyToOne
@JoinColumn(name = "CMPY")
private Company company;
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "DLR")
private Dealer dealer;
@ManyToOne
@JoinColumn(name = "CANCELRSN")
private DynamicList reasonForCancel;
@ManyToOne
@JoinColumn(name = "CLSFC")
private DynamicList classification;
@OneToOne(optional = true, cascade = { CascadeType.ALL }, mappedBy = "enquiry")
private Issue issue;
@OneToMany(cascade = { CascadeType.ALL }, mappedBy = "enquiry", fetch = FetchType.EAGER)
@Where(clause = "CTEXT = 'SUBJ'")
private List<EnquiryText> subject;
@OneToMany(cascade = { CascadeType.ALL }, mappedBy = "enquiry", fetch = FetchType.EAGER)
@Where(clause = "CTEXT = 'PROBL'")
private List<EnquiryText> problemDescription;
@OneToMany(cascade = { CascadeType.ALL }, mappedBy = "enquiry", fetch = FetchType.EAGER)
@Where(clause = "CTEXT = 'DIAGN'")
private List<EnquiryText> diagnosis;
@OneToMany(fetch = FetchType.LAZY, mappedBy = "enquiry")
private List<EnquiryText> texts;