求助!创建视图的问题

[qinglu008]

create view TempStoreV
as

select TempStore.BookId,TempStore.UserId,BookType.Name,Book.Name as Expr1,Book.Author,Book.Translator,Book.Publisher,Book.Price,Book.Discont,Book.Status

from BookType Inner join Book on BookType.ID=TempStore.BookId left outer join UserInfo on TempStore.UserId=UserInfo.Id

我创建以上视图时提示出错.
服务器: 消息 107，级别 16，状态 1，行 1
列前缀 'TempStore' 与查询中所用的表名或别名不匹配。

我找了很久也没有发现问题...
请问错在哪里..谢谢

[青锋-SS]

没有关联TempStore表

[rookie_one]

........left outer join UserInfo on TempStore.UserId=UserInfo.Id

谁跟userInfo连？left outer join前应该有个表名

[中国风]

列前缀 'TempStore' 与查询中所用的表名或别名不匹配
提示很明确TempStore里没有语句中指定的列名

[tm_zn]

检查你的表连接语句
BookType Inner join Book on BookType.ID=TempStore.BookId
--应该是表BookType 和 表Book 连吧怎么跑出TempStore表来了??

left outer join UserInfo on TempStore.UserId=UserInfo.Id

[tm_zn]

应该有四张表啊UserInfo读者信息,TempStore库存,Book图书,BookType书类
按你需求的话表连接这样连试一下
select TempStore.BookId,TempStore.UserId,BookType.Name,Book.Name as Expr1,Book.Author,Book.Translator,Book.Publisher,Book.Price,Book.Discont,Book.Status

from

UserInfo right join TempStore on TempStore.UserId=UserInfo.Id left join Book on TempStore.BookId(如果有的话) left join BookType on BookType.ID=Book.BookTypeID(如果有的话)