[hibernate-dev] How join for two arbitrary tables?

lution for this apart from native SQL? Regards, ManiKanta G ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain informati

[hibernate-dev] Case...When..then... problem

expected AST node: query) exception. Can any one suggest me what am I doing wrong? or is there any work around for this. I need this very urgent. Thanks in advance. Regards, ManiKanta G ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to

[hibernate-dev] Hibernate join problem

Hi, I have two tables (drug_master, cds_drugstore) with cds_master.drug_id reference to drug_master.id. I want to fetch all the drugids, drug_name, sum of avaialble drugs (if avaialable, or else null). I have this native MySql query, which is working fine. but I am unable to port this in t