问题如下:
SELECT Classroom_ID FROM classroom where Classroom_ID NOT IN (
select Classroom_ID From application t1 Where "201601072" >= t1.Time_begin And "201603025" <= t1.Time_end
UNION
select Classroom_ID From application t2 Where "201601072" <= t2.Time_begin And "201603025" >= t2.Time_end
UNION
select Classroom_ID From application t3 Where "201601072" <= t3.Time_end And "201603025" >= t3.Time_end
UNION
select Classroom_ID From application t4 Where "201601072" >= t4.Time_end And "201603025" <= t4.Time_begin );解释:虽然语法是对的但是运行一直错。解决办法
表的别名前加 as
SELECT Classroom_ID FROM classroom where Classroom_ID NOT IN (
select Classroom_ID From application t1 Where "201601072" >= t1.Time_begin And "201603025" <= t1.Time_end
UNION
select Classroom_ID From application t2 Where "201601072" <= t2.Time_begin And "201603025" >= t2.Time_end
UNION
select Classroom_ID From application t3 Where "201601072" <= t3.Time_end And "201603025" >= t3.Time_end
UNION
select Classroom_ID From application t4 Where "201601072" >= t4.Time_end And "201603025" <= t4.Time_begin );解释:虽然语法是对的但是运行一直错。解决办法
表的别名前加 as
解决方案 »
- 请高手指点DB2数据库中数据导入到MYSQL中
- mysql导入数据的中文乱码问题
- phpMyadmin配置问题
- 要了亲命了!!!
- 一个显示MySQL运行状况的报表都应该包含些什么内容?
- 关于insert的问题,帮忙看看
- postgresql数据库又类似phpadmin的数据管理软件吗?
- 怎样才能只显示一个表中的所有字值,而不是显示整个表的结构?
- mysql++ 1.7.9 + mysql 4.0.15的艰辛历程, 还是没有搞定, 请相助
- 读取数据库中固定行的前后左右数据
- yii框架里面我在新建活动的时候保存了活动的开始时间和结束时间在数据库中,现在要根据保存的开始、结束时间和当前时间来判断活动的状态。
- mysql中关于check约束撤销的问题
mysql> SELECT Classroom_ID FROM classroom where Classroom_ID NOT IN (
-> select Classroom_ID From application t1 Where "201601072" >= t1.Time_begin And "201603025" <= t1.Time_end
-> UNION
-> select Classroom_ID From application t2 Where "201601072" <= t2.Time_begin And "201603025" >= t2.Time_end
-> UNION
-> select Classroom_ID From application t3 Where "201601072" <= t3.Time_end And "201603025" >= t3.Time_end
-> UNION
-> select Classroom_ID From application t4 Where "201601072" >= t4.Time_end And "201603025" <= t4.Time_begin );
Empty set (0.03 sec)mysql>