青岛二中高中校服:我的SQL语句怎么错了?

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/07 05:09:09
我要连接dbo.bookinfo和dbo.storage着两张表但不知道错在那了?
select dbo.bookinfo bookid,dbo.storage bookid,
from dbo.bookinfo
join dbo.storage
where dbo.bookinfo bookid=dbo.storage bookid
语法错误,执行SQL语句失败!
错误信息为:ODBC--调用失败。

select dbo.bookinfo.bookid,dbo.storage,.bookid,
from dbo.bookinfo
join dbo.storage
where dbo.bookinfo.bookid=dbo.storage.bookid

select dbo.bookinfo.bookid,dbo.storage.bookid
from dbo.bookinfo, dbo.storage
where dbo.bookinfo.bookid=dbo.storage.bookid

select bookid,
from dbo.bookinfo
join dbo.storage
where dbo.bookinfo.bookid=dbo.storage.bookid
试试