HQL

Basic

Select

• Mysql syntax

SELECT * FROM TableMenu;

• HQL Syntax

FROM tablemenu;

Join

SELECT m.MenuName, o.OptionName 
FROM 
`devmenutest`.menu as m 
LEFT OUTER JOIN 
`devmenutest`.menuoption as o 
ON 
m.id=o.MenuId

• HQL Syntax

SELECT m.menuName , o.optionName
FROM
Menu as m
LEFT OUTER JOIN
m.menuoptions as o