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 HQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL" Watch "HQL" New topic
Author

HQL

rucha kulkarni
Greenhorn

Joined: Aug 05, 2010
Posts: 22
Hello

how should I write the following query in HQL

SELECT * FROM Table1 T1,Table T2 WHERE T1."XYZ" = T2."XYZ"

I have 2 pojo classes for Table1 and Table2

Please help

Thanks,
Rucha
Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1649
    
    7

Please UseCodeTags when posting code or configuration.

The information you provided would be appropriate if you were asking us to help you write the SQL. HQL is based on objects, so for us to help you with this we need to see your objects and the hibernate relationships.


[How To Ask Questions][Read before you PM me]
 
wood burning stoves
 
subject: HQL