INSERT INTO [biaowc]
SELECT * FROM fhbiaowc inner join fhbiao ON fhbiaowc.ubiaohao=fhbiao.ubiaohao
WHERE fhbiao.factory = '株洲'
order by fhbiaowc.ubiaohao
错误提示:'column name or number of suplied values does not match table definition'
但是用INSERT INTO [biaowc] SELECT * FROM fhbiaowc 却可以,为什么?
SELECT * FROM fhbiaowc inner join fhbiao ON fhbiaowc.ubiaohao=fhbiao.ubiaohao
WHERE fhbiao.factory = '株洲'
order by fhbiaowc.ubiaohao
错误提示:'column name or number of suplied values does not match table definition'
但是用INSERT INTO [biaowc] SELECT * FROM fhbiaowc 却可以,为什么?
(fields1,fields2) values
SELECT fields1,fields2 FROM fhbiaowc inner join fhbiao ON fhbiaowc.ubiaohao=fhbiao.ubiaohao
WHERE fhbiao.factory = '株洲'
order by fhbiaowc.ubiaohao字段必须一样
SELECT fhbiaowc.* FROM fhbiaowc inner join fhbiao ON fhbiaowc.ubiaohao=fhbiao.ubiaohao
WHERE fhbiao.factory = '株洲'
order by fhbiaowc.ubiaohaoorINSERT INTO [biaowc]
SELECT fhbiaowc.id, fhbiao.name '注意select的字段顺序要和biaowc表中的字段对应'
FROM fhbiaowc inner join fhbiao ON fhbiaowc.ubiaohao=fhbiao.ubiaohao
WHERE fhbiao.factory = '株洲'
order by fhbiaowc.ubiaohao
因为 从一个表中选择,只有这个表的所有字段,而inner join后确有2个表的所有字段了。INSERT INTO [biaowc](fields1,fields2) values
SELECT fields1,fields2 FROM fhbiaowc inner join fhbiao ON fhbiaowc.ubiaohao=fhbiao.ubiaohao
WHERE fhbiao.factory = '株洲'
order by fhbiaowc.ubiaohao
order by fhbiaowc.ubiaohao 是不可以的,
条件是这2个表的结构一样!