SELECT T.bDirDown, S.nSJID, S.cName, S.nLineID, L.cLineName, B.Name,
S.nFromStaID, T.cStationName, S.nToStaID, T_1.cStationName AS Expr1,
S.dStartTime, S.dEndTime, B.UPStartStation, B.UPEndStation, B.UPStartTime,
B.UPEndTime
FROM S INNER JOIN
L ON S.nLineID = L.nLineID INNER JOIN
T ON S.nFromStaID = T.nStationID INNER JOIN
T AS T_1 ON S.nToStaID = T_1.nStationID INNER JOIN
B ON L.cLineName = B.Name AND T.cStationName = B.UPStartStation AND
T_1.cStationName = B.UPEndStation
以上查得个结果表我想实现 其中的 dStartTime=UPStartTime 怎么写语句呢?
S.nFromStaID, T.cStationName, S.nToStaID, T_1.cStationName AS Expr1,
S.dStartTime, S.dEndTime, B.UPStartStation, B.UPEndStation, B.UPStartTime,
B.UPEndTime
FROM S INNER JOIN
L ON S.nLineID = L.nLineID INNER JOIN
T ON S.nFromStaID = T.nStationID INNER JOIN
T AS T_1 ON S.nToStaID = T_1.nStationID INNER JOIN
B ON L.cLineName = B.Name AND T.cStationName = B.UPStartStation AND
T_1.cStationName = B.UPEndStation
以上查得个结果表我想实现 其中的 dStartTime=UPStartTime 怎么写语句呢?
解决方案 »
- 求一条SQL语句
- Microsoft SQL Server 2005 安装程序
- 怎么样才能合并sql并按b表的字段排序啊
- 一个非常初学的问题varchar与nvarchar有何区别
- 如何将数据库中的文本分行按原样输出????
- 如果使用sql脚本往数据已有数据表中添加字段
- sql从表A中查询出字段"名字"的内容为张三,字段"性别"的内容为李四,如何在点击"张三"(这个设为超连接)后,显示出表2中字段"名字"内容为张三的其他信息
- 高手请帮忙!!!为什么提示"视图定主义中没有输出列或FORM子句中没有项目"
- 求助
- 菜鸟请教(关于数据加载)
- 难道 sql server 2005比 2000落后
- 【求助】存储过程报错
SELECT T.bDirDown, S.nSJID, S.cName, S.nLineID, L.cLineName, B.Name,
S.nFromStaID, T.cStationName, S.nToStaID, T_1.cStationName AS Expr1,
S.dStartTime, S.dEndTime, B.UPStartStation, S.dStartTime as UPEndStation, B.UPStartTime,
B.UPEndTime
FROM S INNER JOIN
L ON S.nLineID = L.nLineID INNER JOIN
T ON S.nFromStaID = T.nStationID INNER JOIN
T AS T_1 ON S.nToStaID = T_1.nStationID INNER JOIN
B ON L.cLineName = B.Name AND T.cStationName = B.UPStartStation AND
T_1.cStationName = B.UPEndStation
(
SELECT T.bDirDown, S.nSJID, S.cName, S.nLineID, L.cLineName, B.Name,
S.nFromStaID, T.cStationName, S.nToStaID, T_1.cStationName AS Expr1,
S.dStartTime, S.dEndTime, B.UPStartStation, B.UPEndStation, B.UPStartTime,
B.UPEndTime
FROM S INNER JOIN
L ON S.nLineID = L.nLineID INNER JOIN
T ON S.nFromStaID = T.nStationID INNER JOIN
T AS T_1 ON S.nToStaID = T_1.nStationID INNER JOIN
B ON L.cLineName = B.Name AND T.cStationName = B.UPStartStation AND
T_1.cStationName = B.UPEndStation
)
update t set dStartTime=UPStartTime
试试