Troy McKinnon wrote:
I have been reading thru the documentation on the hibernate query language regarding joins and other 'sql' queries.
I noticed that in every case of a join the 2 tables have an association. (constraint)
I was wondering if it is still possible to do the join without the relation.
This example is trivial but it gets my point across: select x.name from Table_One x, Table_Two y
where x.name = y.name (+)
and y.type is null
Or similarly:
select x.name from Table_One x, Table_Two y
where x.name = y.someothername (+)
and y.type is null
I don't want to 'force' the mapping as in:
<class Table_one> <id> <one-to-one ... class=Table_2> <..>
Because I feel that that would limit me from doing a similar join on say Table_3.yetanothername
This is probably a very simple answer and I just am not getting it. But I would appreciate your help in understanding.
Thanks
Troy
------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-- Gavin King JBoss Group +61 410534454 http://hibernate.org
------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
