在Access中创建视图的问题

Question

涉及2个表（WenZhangZhiLiao，HuiYuanZhiLiao）和一个视图（ST_LeiMing），其中WenZhangZhiLiao的PinBiRen字段和FaTieRen字段分别与HuiYuanZhiLiao的id字段相关联，WenZhangZhiLiao的XiaoLei字段和ST_LeiMing的id_XiaoLei字段相关联
我是这样写Sql语句的：
string tj="create view ST_PB(id,BiaoTi,FaTieRen,ZhuoZhe,FaTieShiJian,FaTieIP,PinBi,ShuoShuID,XiaoLei,HuiYuanZhiLiao.WangMing,HuiYuanZhiLiao_1.WangMing,id_DaLei) as select WenZhangZhiLiao.id,WenZhangZhiLiao.BiaoTi,WenZhangZhiLiao.FaTieRen,WenZhangZhiLiao.ZhuoZhe,WenZhangZhiLiao.FaTieShiJian,WenZhangZhiLiao.FaTieIP,WenZhangZhiLiao.PinBi,WenZhangZhiLiao.ShuoShuID,WenZhangZhiLiao.XiaoLei,HuiYuanZhiLiao.WangMing,HuiYuanZhiLiao_1.WangMing,ST_LeiMing.id_DaLei from ST_LeiMing,HuiYuanZhiLiao,WenZhangZhiLiao where HuiYuanZhiLiao_1.id=WenZhangZhiLiao.PinBiRen and HuiYuanZhiLiao.id=WenZhangZhiLiao.FaTieRen and WenZhangZhiLiao.XiaoLei=ST_LeiMing.id_XiaoLei";OleDbCommand tjC=new OleDbCommand(tj,MyConnection);
tjC.Connection.Open();
tjC.ExecuteNonQuery();
tjC.Connection.Close();但提示出错：IErrorInfo.GetDescription 因 E_FAIL(0x80004005) 而失败。请问这个创建视图的语句该怎么写？

Answer 1

首先,你这个SQL语句写得太不工整了,于人于已都很难看.
你可以把这个SQL语句放到ACCESS数据库中运行一下,看有没有问题.