title: HQL projection on entities/tables
body: <p>I have two tables with one to one relationship - Person and House
  I tried to use HQL projection like Select p.name, p.dob from Person which returns me the name and dob fine.
  However, I dont know how to use projection in HQL if:
  1. I want to include the House
  2. I want to include only color and year of the House.</p>
  
  <p>i tried <code>SELECT p.firstName, p.lastName p.house FROM Person p" </code>but got error with "could not resolve property". What do i need to do to get this right? thanks</p>