MYSQL语句,创建一个试图。代码如下:
CREATE view vi_stat as
select * from tbcontrol left join
(select T_Code, min(tbtask.T_AStart) as minstart,max(tbtask.T_AEnd)as maxend,sum(tbtask.T_PDay) as num from tbtask group by left(tbtask.T_Code, 8)) as b
on tbcontrol.C_Code = left(b.T_Code,8)出现错误:
Error Code : 1349
View's SELECT contains a subquery in the FROM clause去掉CREATE view vi_stat as 后,查询结果是正确的,现在想建立视图,出现以上错误。
CREATE view vi_stat as
select * from tbcontrol left join
(select T_Code, min(tbtask.T_AStart) as minstart,max(tbtask.T_AEnd)as maxend,sum(tbtask.T_PDay) as num from tbtask group by left(tbtask.T_Code, 8)) as b
on tbcontrol.C_Code = left(b.T_Code,8)出现错误:
Error Code : 1349
View's SELECT contains a subquery in the FROM clause去掉CREATE view vi_stat as 后,查询结果是正确的,现在想建立视图,出现以上错误。
解决方案 »
- “在事务中,不能存在多个使用此游标类型的记录集”问题
- 问个查询语句
- sql server安装失败原因总结及解决方案,小弟也只有这么一点,还望大家共享
- 请教SQL2000在手动备份后就无法自动备份了
- 为何我在删除SQL SERVER2000时总是删不掉```因为当想重新安装时总是说``以前安装过```我重启也没有用````反而总是在桌面上出现 WINDOWS I
- 紧急求助SQL高手:(100)
- 数据统计
- 关于sqlserver展bom阶的问题
- 怎么判断数据表里的某一列是正常的int类型列还是自动编号标识列
- 向邹建、大力,求一方法。
- SQL删除指定字符间的字符串
- 该语句如何用 not exists 改写
select
T_Code,
min(tbtask.T_AStart) as minstart,
max(tbtask.T_AEnd)as maxend,
sum(tbtask.T_PDay) as num
INTO #TB from tbtask
group by left(tbtask.T_Code, 8)) CREATE view vi_stat as
select * from tbcontrol left join
#TB as b
on tbcontrol.C_Code = left(b.T_Code,8) 试试看!!
CREATE VIEW vi_stat
AS
SELECT
LEFT(T_Code,8) AS T_Code,
min(tbtask.T_AStart) as minstart,
max(tbtask.T_AEnd)as maxend,
sum(tbtask.T_PDay) as num
FROM tbtask
GROUP BY LEFT(T_Code,8);然后再写SQLSELECT *
FROM tbcontrol left join vi_stat AS B
ON tbcontrol.C_Code = B.T_Code
INNER JOIN vi_stat AS B
ON A.T_Code=B.Code
SET
A.`start` = B.minstart,
A.`end` = B.maxend,
A.num = B.num;