统计只上一门课的老师

最新推荐文章于 2024-07-16 19:15:34 发布

czm1303

最新推荐文章于 2024-07-16 19:15:34 发布

阅读量117

点赞数

本文链接：https://blog.csdn.net/czm1303/article/details/88937270

版权

        private void button5_Click(object sender, EventArgs e)
        {
            string s = "select teachers.tname as 姓名,courses.cnum as 课程号,courses.cname as 课程名,";
            s += "courses.ctime as 课时 from teachers,courses ";
            s += "where courses.tnum=teachers.tnum ";
            s += "and teachers.tnum in (select tnum from courses group by tnum having count(cnum)=1)";
            loadLV(listView2, s);
        }