一个学科表(Field),一个用户表(User),多对多关系。
学科表有两个字段,id和descripiton,用户表有众多字段,不罗列了Field中有SET集合users
User中有SET集合fields现在要查掌握id like '520%'的女性用户
我这样写的:
from User u,Field f where u.gender='m' in (select f.users from Field where f.id like '520%')持续报错!高分献上,谢谢帮助
学科表有两个字段,id和descripiton,用户表有众多字段,不罗列了Field中有SET集合users
User中有SET集合fields现在要查掌握id like '520%'的女性用户
我这样写的:
from User u,Field f where u.gender='m' in (select f.users from Field where f.id like '520%')持续报错!高分献上,谢谢帮助
from User u where u.gender='m' and u in elements(select f.users from Field f where f.id like '520%')
还不行,快要跪求了
in0_, user0_.isCityer as isCityer0_, user0_.password as password0_, user0_.name as name0_, user0_.gender as gender0_, user0_.birthday as birthday0_, user0_.city as city0_, user0_.m
obilephone as mobilep13_0_, user0_.identify as identify0_, user0_.email as email0_, user0_.address as address0_, user0_.college as college0_, user0_.res as res0_, user0_.up
datetime as updatetime0_, user0_.tips as tips0_, user0_.trains as trains0_ from test.t_user user0_ where user0_.gender='m' and (user0_.id in (select . from test.t_field field1_, r_
user_field users2_, test.t_user user3_ where field1_.id=users2_.field_id and users2_.user_id=user3_.id and (field1_.id like '520%')))
16:56:29,171 WARN JDBCExceptionReporter:100 - SQL Error: 1064, SQLState: 42000
16:56:29,171 ERROR JDBCExceptionReporter:101 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
'from test.t_field field1_, r_user_field users2_, test.t_user user3_ where field1' at line 1
select f.users from Field f where f.id like '520%'可以查
from User u where u.gender = 'm'也可以查怎么这两个组合起来就不能查呢,我快崩溃了