"and grade.isdual=0 "+
"and (courseinfo.cou_day, courseinfo.cou_time) in "+
"(select cou_day, cou_time from courseinfo where "+
"cou_id='"+cou_id+"')";
------解决思路----------------------
可在程序中设定断点,查看SQL拼接结果,然后手工在查询分析器中执行..
------解决思路----------------------
(courseinfo.cou_day, courseinfo.cou_time) in (select cou_day, cou_time from courseinfo where cou_id='')
你的SQL版本是多少，貌似到SQL2005都还不支持这种语法，SQL2008以上情况不清楚