from TktQstActn tqs right join tqs.lkup lk where lk.typ in
('X' , 'Y') and (tqs.tkt.tktNo = '5' or tqs.tkt is null)

select e, (select m.name from Emp m where m.empId = e.managerId) as managerName from Emp e

ORACLE Table
=========

LICENSEE_ENTITY
   entity_id
   state_entity_id      (SELF reference to LICENSEE_ENTITY table)
   entityDescriptiveName

state_entity_id is FK to same LICENSEE_ENTITY table (both entity and state_entity records in the same table)

HQL:  (I want to get the liceseeName and its state name if state exists otherwise null)
====================

select
       licenseeEntity.entityDescriptiveName as licenseeName,
       refStateEntity.entityDescriptiveName as licenseeState
from
     LicenseeEntityDomain as licenseeEntity
     left outer join licenseeEntity.refStateEntity as refStateEntity


Hibernate converts the above HQL like this:
============================

select
  licenseeen0_.ENTITY_DESCRIPTIVE_NAME as col_0_0_,
  bsreflicen1_.ENTITY_DESCRIPTIVE_NAME as col_1_0_
from
  REF_LICENSEE_ENTITY licenseeen0_
left outer join
  REF_LICENSEE_ENTITY bsreflicen1_
   on licenseeen0_.ENTITY_SYSID=bsreflicen1_.REF_STATE_ENTITY_ID

last line is wrong:

instead it should be -
on licenseeen0_.REF_STATE_ENTITY_SYSID=bsreflicen1_.ENTITY_ID

select
       licenseeEntity.entityDescriptiveName as licenseeName,
       (select refStateEntity.entityDescriptiveName from LicenseeEntityDomain as refStateEntity where refStateEntity.entityId = licenseeEntity.stateEntityId) as licenseeState
from
     LicenseeEntityDomain as licenseeEntity

select
       licenseeEntity.entityDescriptiveName as licenseeName,
       (select refStateEntity.entityDescriptiveName from LicenseeEntityDomain as refStateEntity where refStateEntity.entityId = licenseeEntity.stateEntityId) as licenseeState
from
     LicenseeEntityDomain as licenseeEntity

-- in this licenseeEntity.stateEntityId ==> is an Object (as it is self-FKed) so the clause "refStateEntity.entityId = licenseeEntity.stateEntityId" is not valid as one side it is field-name other side it is object.

-- and if u try refStateEntity.entityId = licenseeEntity.stateEntityId.entityId, then hibernate throws 'null-pointer-exception' as stateEntityId (object) would be null in some cases.

package au.com.lawlex.taipan.app.core.node;

import java.util.Collection;
import java.util.Collections;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name = "node_tree_new")
public class NodeLightNew
  implements java.io.Serializable
{

  private long nodeId;
  private Long categoryId;
  private NodeLightNew category;
  private Collection<NodeLightNew> subCategories = Collections.emptyList();
  private String name;

  public NodeLightNew()
  {
  }

  @Column(name = "node_id", unique = true, nullable = false)
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  @Id
  public long getNodeId()
  {
    return nodeId;
  }

  public void setNodeId(final long nodeId)
  {
    this.nodeId = nodeId;
  }

  @Column(name = "category_id", insertable = false, updatable = false)
  public Long getCategoryId()
  {
    return this.categoryId;
  }

  public void setCategoryId(final Long categoryId)
  {
    this.categoryId = categoryId;
  }

  @ManyToOne(optional = true)
  @JoinColumn(name = "category_id", nullable = true)
  public NodeLightNew getCategory()
  {
    return this.category;
  }

  public void setCategory(final NodeLightNew category)
  {
    this.category = category;
  }

  @OneToMany(targetEntity=au.com.lawlex.taipan.app.core.node.NodeLightNew.class, mappedBy = "category")
  public Collection<NodeLightNew> getSubCategories()
  {
    return this.subCategories;
  }

  public void setSubCategories(final Collection<NodeLightNew> subCategories)
  {
    this.subCategories = subCategories;
  }

  @Column(name = "name", nullable = false)
  public String getName()
  {
    return this.name;
  }

  public void setName(final String name)
  {
    this.name = name;
  }

} // end class NodeLight

select nl1.name, (select nl2.name from NodeLightNew nl2 where nl1.categoryId = nl2.nodeId) from NodeLightNew nl1

select nl1.nodeId, nl1.name, nl2.name from NodeLightNew nl1 left outer join nl1.category nl2