SQL语句报错,请赐教

[lichenbo]

语句如下:
insert into db_0003.dbo.MF_IJ select * from db_0002.dbo.MF_IJ
where db_0003.dbo.MF_IJ.ij_no <>db_0002.dbo.MF_IJ.ij_no
and db_0002.dbo.MF_IJ.IJ_NO like '%WO%'
OR db_0002.dbo.MF_IJ.BIL_TYPE='01'
OR db_0002.dbo.MF_IJ.BIL_TYPE='02'
OR db_0002.dbo.MF_IJ.BIL_TYPE='03'
OR db_0002.dbo.MF_IJ.BIL_TYPE='04'
OR db_0002.dbo.MF_IJ.BIL_TYPE='05'

在查询分析器里面执行后显示如下错误:

服务器: 消息 107，级别 16，状态 3，行 1
列前缀 'db_0003.dbo.MF_IJ' 与查询中所用的表名或别名不匹配。

我检查了数据库名和表名都正确的,但还是报这样的错误,请各位高手赐教

[正牌风哥]

insert   into   db_0003.dbo.MF_IJ   
select   a.*   
from   
	db_0002.dbo.MF_IJ  a, db_0003.dbo.MF_IJ b
where   
	b.ij_no   <> a.ij_no 
	and   a.IJ_NO   like   '%WO%'   
	OR   a.BIL_TYPE='01'   
	OR 	a.BIL_TYPE='02'   
	OR   a.BIL_TYPE='03'   
	OR 	 a.BIL_TYPE='04'   
	OR   a.MF_IJ.BIL_TYPE='05' 

[lichenbo]

还是提示错误:
列前缀 'a.MF_IJ' 与查询中所用的表名或别名不匹配。

[正牌风哥]

确实一下MF_IJ有没有这一列db_0002.dbo.MF_IJ db_0002数据库MF_IJ表中

[lichenbo]

MF_IJ是表,ij_no是字段

[正牌风哥]

insert   into   db_0003.dbo.MF_IJ   
select   a.*   
from   
    db_0002.dbo.MF_IJ  a, db_0003.dbo.MF_IJ b
where   
    b.ij_no   <> a.ij_no 
    and   a.IJ_NO   like   '%WO%'   
    OR   a.BIL_TYPE='01'   
    OR     a.BIL_TYPE='02'   
    OR   a.BIL_TYPE='03'   
    OR      a.BIL_TYPE='04'   
    OR   a.BIL_TYPE='05' --这里改一下

[hbzy123]

insert into db_0003.dbo.MF_IJ select * from db
------------------------
上面这句要保证db_0003.dbo.MF_IJ和db_0002.dbo.MF_IJ 的表结构一致.看下db_0003.dbo.MF_IJ是否有自动增长的字段,
自动增加的字段不允许插入.除非设置了: set idetity_insert table_name on
建议还是指定列来插入,
例如:
insert into t1(id1,id2)
select id1,id2 from t2

[lichenbo]

db_0003.dbo.MF_IJ和db_0002.dbo.MF_IJ的表结构一致.
楼上的高手说指定列来插入,但我要把所有的列都追加上去,

[JL99000]

insert into db_0003.dbo.MF_IJ
select a.*
from
db_0002.dbo.MF_IJ a, db_0003.dbo.MF_IJ b
where
b.ij_no <> a.ij_no
and a.IJ_NO like '%WO%'
OR a.BIL_TYPE='01'
OR a.BIL_TYPE='02'
OR a.BIL_TYPE='03'
OR a.BIL_TYPE='04'
OR a.MF_IJ.BIL_TYPE='05'
把db_0003.dbo.MF_IJ改成a