多表查询问题 在线等 来看看嘛~~~

[netboygg]

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参数？

[caoyuechun]

@xiongkahao,要给你的command的参数里添加

[伴老思源]

SQL语句没错

[伴老思源]

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)

[liushui1981]

语句是没错误的！！！你把 程序代码帖出来看看