[jboss-user] [EJB 3.0] - Re: HQL/ JPA-QL Query Tuning: How to enforce the join order

[fhh]

  | select *
  |    from Table1 T1, Table2 T2, Table3 T3
  |    where T1.Key3_ID = T3.Key3_ID 
  |       and T1.Key2_ID + 0 * T3.Key3_ID =T2.Key2_ID
  | 

This is just sick disgusting rubbish! Who ever invented that stuff - fire him!

Regards

Felix

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4042948#4042948

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4042948