我有两个表:History(CardID,StationID,StationHeadID,InStationHeadTime,OutStationHeadTime)
StationTimeTemp(CardID,StationID,StationHeadID,InOROut,InStationHeadTime)
其中表StationTimeTemp的主键为(CardID,StationID,StationHeadID)共同组成,
想通过主键查询得到表StationTimeTemp的InStationHeadTime属性列作为History的InStationHeadTime列值,连同其他列值
一起插入表History,请问SQL语句怎么写啊?
StationTimeTemp(CardID,StationID,StationHeadID,InOROut,InStationHeadTime)
其中表StationTimeTemp的主键为(CardID,StationID,StationHeadID)共同组成,
想通过主键查询得到表StationTimeTemp的InStationHeadTime属性列作为History的InStationHeadTime列值,连同其他列值
一起插入表History,请问SQL语句怎么写啊?
select
CardID
,StationID
,StationHeadID
,InStationHeadTime=case InOROut when 'IN' then InStationHeadTime end
,OutStationHeadTime=case InOROut when 'OUT' then InStationHeadTime end
from StationTimeTemp
?
StationTimeTemp(CardID,StationID,StationHeadID,InOROut,InStationHeadTime)
其中表StationTimeTemp的主键为(CardID,StationID,StationHeadID)共同组成,
现在通过硬件读到History里的(CardID,StationID,StationHeadID,OutStationHeadTime) 这四个属性,而另外一个属性需要从StationTimeTemp根据主键查询得到(这是硬件之前读到的数据),然后和硬件读到的数据一起写入History,怎么实现?
from History