Hi guys.. Got the following problem:
I have a Class called Categoria (Category) that has a List of categories (sub-categories). I'm trying to build a HQL query that can gives me all the Categories that are not a subcategory of another category. In SQL is dead simple : SELECT cat.id FROM Categoria cat LEFT OUTER JOIN subCategoria sc ON cat.id != sc.padre_id So far I haven't been able to build a equivalent HQL query. Please help, Thanks. I know that I could use the SQL, but I want to keep all my DAO layer in HQL, it is better for sanity checks. -- View this message in context: http://www.nabble.com/SQL-v.s.-HQL-%28plz-help%29-tf4002808s2369.html#a11369137 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
