Home / Questions / 158650
Accepted
Francrt
Asked: 2020-04-24 23:38:23 +0800 CST 2020-04-24 23:38:23 +0800 CST

HQL exclusive between tables

  • 772

I need a couple of exclusive Queries to check an "availability" factor within a db.

The query is okay so far I have been raising it in various ways and I think this is the most correct but it keeps giving me an error

    from Usuario judge where judge.juez = 1 and judge.idusuario  not in Usuariomaraton

Could someone tell me what is wrong with the query that is why I am not able to extract what I am looking for (All users that have judge value 1 and are not in the Usuariomaraton table).

hibernate

1 Answers

  1. Best Answer

    Friend look in sql it would be like this

    select * from Usuario judge where judge.juez = 1 and judge.idusuario  not in 
(select idusuario from Usuariomaraton)

    If you look at the 'in' I associate it to a query and not to an object check the subqueries documentation https://docs.jboss.org/hibernate/orm/3.5/reference/es-ES/html/queryhql.html# queryhql-subqueries

    • 0