把tb2中的marketId ，StockId不存在于tb1中的记录插入到tb1中。这样写么？该如何解决
日期：2014-05-18 浏览次数：20589 次
把tb2中的marketId ，StockId不存在于tb1中的记录插入到tb1中。这样写么？？？
insert into tb1 (MarketId, StockId, NewPrice)
select MarketId, StockId, NewPrice
from tb2
where not ( MarketId in (select MarketId from tb1) and StockId in (Select StockId from tb1))
把tb2中的marketId ，StockId不存在于tb1中的记录插入到tb1中。这样写么？？？
另外 下面这句和上面这句一样么？？转不过弯来了。感觉不一样啊。。。
insert into tb1 (MarketId, StockId, NewPrice)
select MarketId, StockId, NewPrice
from tb2
where ( MarketId not in (select MarketId from tb1) and StockId not in (Select StockId from tb1))
------解决方案--------------------
insert into tb1 (MarketId, StockId, NewPrice)
select MarketId, StockId, NewPrice
from tb2
where not ( MarketId in (select MarketId from tb1) and StockId in (Select StockId from tb1))
把tb2中的marketId ，StockId不存在于tb1中的记录插入到tb1中。这样写么？？？
另外 下面这句和上面这句一样么？？转不过弯来了。感觉不一样啊。。。
insert into tb1 (MarketId, StockId, NewPrice)
select MarketId, StockId, NewPrice
from tb2
where ( MarketId not in (select MarketId from tb1) and StockId not in (Select StockId from tb1))
------解决方案--------------------
- SQL code
insert tb1 select MarketId, StockId, NewPrice from tb2 a where not exists(select 1 from tb1 a where a.MarketId=b.MarketId and a.StockId=b.StockId)
------解决方案--------------------
- SQL code
insert into tb1 (MarketId, StockId, NewPrice)
select MarketId, StockId, NewPrice
from tb2
where not ( MarketId in (select MarketId from tb1) and StockId in (Select StockId from tb1))
--这句错了
insert into tb1 (MarketId, StockId, NewPrice)
select MarketId, StockId, NewPrice
from tb2
where MarketId not in(select MarketId from tb2)
and StockId not in(select StockId from tb2)
--这样写可以，但是逻辑上有问题，还是用exists的吧
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
