Have Geek Brain

How to get the value of the 2nd table form without participating in sleep mode

Hi I have a CHECKPRODUCT table.

i also has a second table CHECKSTATUS_LOOKUP with column name DESCRIPTION

while I get values ​​from CHECKPRODUCT, I also want the value from the DESCRIPTION column of the second table (CHECKSTATUS_LOOKUP), but I don't want to join both tables. are there any ways to do this

-1


a source to share


2 answers


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



In most cases, you can use a subquery instead of a join.

+1


a source


Only advice. When using Hibernate or NHibernate it is better to talk about class + properties instead of table + fields.



+1


a source






More articles:


All Articles