Hi,

I got information of hibernate-relationships but in my
case, the relationship are very complex.
Do you know if is posible get information from some
tables, with a query like that:


select Mch.MultiChannelHierDes, Mch.MultiChannelHierID
from Business.Users Usr Inner Join
Business.ChannelXCustomer Cxc
        on Usr.ChannelID = Cxc.ChannelID and
Usr.ChannelXCustomerID=Cxc.ChannelXCustomerID 
Inner Join Business.MultiChannelXCus Mxc 
        on Cxc.ChannelID =Mxc.ChannelID and
Cxc.ChannelXCustomerID=Mxc.ChannelXCustomerID 
Inner Join Business.MultiChannelHier Mch 
        on Mcx.MultiChannelHierID=Mch.MultiChannelHierID 
where Usr.UserID='xxx'


Thanks for your information,

                     JMC


        
                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 


-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

Reply via email to