INSERT INTO gerenjilu
(xiongkahao, xingming, xingbie, danweimc, gangweimc, laobaomc, shuliang, lingqusj, jldanwei)
SELECT zhigong.xiongkahao, zhigong.xingming, zhigong.xingbie, zhigong.danweimc, zhigong.gangweimc, gangweilaobao.laobaomc, gangweilaobao.shuliang,
GETDATE() AS lingqusj, laobaoyp.jldanwei
FROM zhigong INNER JOIN
gangweilaobao ON gangweilaobao.gangweimc = zhigong.gangweimc INNER JOIN
laobaoyp ON gangweilaobao.laobaomc = laobaoyp.laobaomc
WHERE (zhigong.xiongkahao = @xiongkahao)就查几个表里相同的数据 再把结果插入到另一个表里
这个对不对
最好的办法是什么?
这个在vs.net查询器里恩能够工作,为什么这个在winform里 没有找到@xiongkahao参数?
(xiongkahao, xingming, xingbie, danweimc, gangweimc, laobaomc, shuliang, lingqusj, jldanwei)
SELECT zhigong.xiongkahao, zhigong.xingming, zhigong.xingbie, zhigong.danweimc, zhigong.gangweimc, gangweilaobao.laobaomc, gangweilaobao.shuliang,
GETDATE() AS lingqusj, laobaoyp.jldanwei
FROM zhigong INNER JOIN
gangweilaobao ON gangweilaobao.gangweimc = zhigong.gangweimc INNER JOIN
laobaoyp ON gangweilaobao.laobaomc = laobaoyp.laobaomc
WHERE (zhigong.xiongkahao = @xiongkahao)就查几个表里相同的数据 再把结果插入到另一个表里
这个对不对
最好的办法是什么?
这个在vs.net查询器里恩能够工作,为什么这个在winform里 没有找到@xiongkahao参数?
xingming,
xingbie,
danweimc,
gangweimc,
laobaomc,
shuliang,
lingqusj,
jldanwei)
SELECT
zhigong.xiongkahao,
zhigong.xingming,
zhigong.xingbie,
zhigong.danweimc,
zhigong.gangweimc,
gangweilaobao.laobaomc,
gangweilaobao.shuliang,
GETDATE() AS lingqusj,
laobaoyp.jldanwei
FROM zhigong
INNER JOIN gangweilaobao
ON gangweilaobao.gangweimc = zhigong.gangweimc
INNER JOIN laobaoyp
ON gangweilaobao.laobaomc = laobaoyp.laobaomc
WHERE (zhigong.xiongkahao = @xiongkahao)