File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Select query with multiple where clause Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Select query with multiple where clause" Watch "Select query with multiple where clause" New topic
Author

Select query with multiple where clause

Shinu Pil
Greenhorn

Joined: Sep 02, 2005
Posts: 9
HI
I have two tables with device and transaction
Device Id of device is the foreign key of transaction

how write hql query Device Id not used in second table
My current hql query for device is

here searchCritiria1,searchCritiria2 column name and searchString1,searchString2 are parameters passed from UI
how i added these sql query to
please help
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Select query with multiple where clause
 
Similar Threads
Deleting Record in a Web Application.
HQL help needed
Stored Procedure inside HQL query?
Help with HQL Insert and Joins using Hibernate 3 / JPA
HQL query for multiple conditions met