select * from homework where studentcontent is null and title not in(select title from homework where studentid="+id+")和这个sql差不多啊,另外你sql语言这么写就行了吧:
select * from homework where studentcontent is null and studentid not like "+id+";你那个title not in (select title from homework where studentid="+id+")不就是找到studentid not like "id"的条件嘛
select * from homework where studentcontent is null and studentid not like "+id+";你那个title not in (select title from homework where studentid="+id+")不就是找到studentid not like "id"的条件嘛
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货