Question

java中的sql能不能有子查询啊

String queStringrynewmoviefilmreview = "select * from filmreview where filmreview.fname NOT IN (select movie.fname from movie where ontime <"+(total-500);

这是我的代码 总报错！

Answer 1

String queStringrynewmoviefilmreview = "select * from filmreview where filmreview.fname NOT IN (select movie.fname from movie where ontime <"+(total-500)+")";

Answer 2

这个跟Java没关系吧，你先拿到数据库客户端上执行一下，没错了再说啊

Answer 3

没看错的话 少半拉括号