Hibernate:HQL语句请教

2025-02-27 22:11:51
推荐回答(3个)
回答1:

select User.* from User join in Status on User.s_id = Status.id where Status.mark = 'SuperAdmin'

回答2:

select name form User where s_id in(select s_id from Status where mark = 'SuperAdmin')

回答3:

HQL:
select u from User u, Status s where u.s_id = s.id and s.mark = 'SuperAdmin'