Hibernate does support Dynamic table??? --------------------------------------- Key: HHH-3983 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3983 Project: Hibernate Core Issue Type: Improvement Reporter: karthikraja Hi, Is there any way to access the dynamic table using Hibernate? ex Select distinct a.field1, b.field2 from (select distinct field2 from tableA) a, (Select distinct field1,field2 from tableB) b where a.field1 = b.field1 This query executing in sql propt. but in HQL throws exception like "Table or view does not exist" How to handle this? is there anything in Hibernate to handle dynamic table?? Thanks, KarthikRaja -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira