how to get value form 2nd table with out join in hibernate

Question

hi i have a table called CHECKPRODUCT.

i also has 2nd table called CHECKSTATUS_LOOKUP with column name DESCRIPTION

while i am getting values from CHECKPRODUCT, i also want value from DESCRIPTION column of 2nd table(CHECKSTATUS_LOOKUP) but i dont want ot join both tables. is there any ways to do that

Answer 1

Please give more details and explain what columns you have in the two tables and what exactly is the requirement.

You could use a subquery instead of a join in most cases.

Answer 2

Only an advise. When you are using Hibernate or NHibernate is better to talk about class+properties instead table+fields