Question

sql语句 怎么从一张表中查询数据插入到另一张表中

Answer 1

select *from scadaserver.dbo.SensorType where ID in (select A.SensorTypeID from scadaserver.dbo.Sensor A WHERE A.Name='第三水厂进水流量' and a.shortName='进水流量');