posted 13 years ago
I have SQL query
It extracts name,start_date and end_date from the pay table where name at the pay table and emp table are the same and the id=16940 and in the emp table the status must be employed.
How do I implement this SQL query using hibernate? My application uses hibernate, till now it was straightforward I have payDAO.java and empDAO.java that queries the pay table and emp table seperately. But I want to implement the above query in which the result is based on both the tables..How I am supposed to implement it..Can someone please throw some light on the problem or give some example?
Thanks.