Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Select query with multiple where clause

 
Shinu Pil
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic