insert into 时子查询语句组合 storargid name shop---------------1 aa 112 bb 123 cc 13shopid name------------------11 a店12 b店13 c店lsTableid storage XX---------------------insert into lsTable (id,storage,xx) values(1,只知道分店id,但是想要的是对于的仓库id, 'XX') 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 insert into lsTable (id,storage,xx) values(1,(select id from storarg where shop=11), 'XX')类似这样的语句 insert into lsTable (id,storage,xx) select shop.id,storarg.id,'XX'from storarg join shop on storarg.shop = shop.id insert into lsTable (id,storage,xx) values(select 1,id,'xx' from storarg where shop=11) insert into lsTable (id,storage,xx) values(1,(select id from strong left join shop on shop.id = strong.shop), 'XX') 看错题意,正确如下:insert into lsTable (id,storage,xx) select m.id , n.id , n.name from storarg m, shop n where m.shop = n.id and m.shop=11 insert into lsTable (id,storage,xx) values(select 1,id,'xx' from storarg where shop=11) insert into lsTable(id, storage, xx)select id, shop, 'XX' from storage left join shop on shop.id = storage.shop SQL Server外键级联删除时 触发器不能正常工作原因 求:top20 order by和unionall和 top20 order by排序 自增列在什么情况下会用到 sql2005 内网可连接,外网连不了??? 如何优化这一句 触发器更新字段问题 如何使用动态公式问题 后台用SQL,前台客户端用什么编好啊?VC合适吗? 这样的情况,我应该如何设计数据库? 我想得到如下的時間格式的字符串yyyy-mm-dd hh24:mi:ss,如何做?convert好象不行。 安装SQL的问题,急啊 求SQL语句
where shop=11), 'XX')
类似这样的语句
select shop.id,storarg.id,'XX'
from storarg join shop
on storarg.shop = shop.id
values(select 1,id,'xx' from storarg where shop=11)
insert into lsTable (id,storage,xx) values(1,(select id from strong left join shop on shop.id = strong.shop), 'XX')
insert into lsTable (id,storage,xx)
select m.id , n.id , n.name from storarg m, shop n where m.shop = n.id and m.shop=11
values(select 1,id,'xx' from storarg where shop=11)
insert into lsTable(id, storage, xx)
select id, shop, 'XX' from storage left join shop on shop.id = storage.shop