I need to run some read only reports by joining the following two tables: 1) payments 2) subscriptions
The join will be on a column in both called paymentreference. I do not have control over the underlying database and the two tables and the two tables do not have a relationship i.e. no foreign keys exist. Is it possible to add the relationship primary and foreign key in the annotations for the pojos and then use hql to perform the join even though there are no keys in the database? At the moment we are using a native sql query and using a results transformer to map the results to a pojo. I am using hibernate 3.2 annotations. Thanks in advance Abu -- View this message in context: http://www.nabble.com/Hibernate-hql-join-on-tables-with-no-relationship-tp17338465s2369p17338465.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
