在进行sql语句拼接时,需要在语句后加上空格,否则就会报错
"select * from lesson a join tb_user b " +
"on a.createId = b.user_id "+
"where cid not in (select cid from joinedclass a join tb_user b on a.uid = b.user_id where uid=#{uid})
在进行sql语句拼接时,需要在语句后加上空格,否则就会报错
"select * from lesson a join tb_user b " +
"on a.createId = b.user_id "+
"where cid not in (select cid from joinedclass a join tb_user b on a.uid = b.user_id where uid=#{uid})