sql 语句的错误问题(30)

H

hedadt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-20

• #1

select a.bookid,a.bookname,a.type,a.price,a.author,a.press,b.ydate from book a ,(select * from borrow where stat=1) as b where a.bookid = b.bookid 在 select * from borrow where stat=1 出错，无效的使用关键字 select

 

D

duxing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-20

• #2

select a.bookid,a.bookname,a.type,a.price,a.author,a.press,b.ydate from book a ,(select * from borrow where stat=1) as b //此处的as 去掉where a.bookid = b.bookid select a.bookid,a.bookname,a.type,a.price,a.author,a.press,b.ydate from book a ,(select * from borrow where stat=1) b where a.bookid = b.bookid

 

Z

znxia

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-20

• #3

问这类问题，最好说明使用的是什么数据库，有的数据库功能比较弱，不支持子查询功能。

 

I

inspur430

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-20

• #4

SYBASE 的话不会错。~~~用 AS和不用AS一样。

 

N

nqs2009

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #5

我怎么感觉好像结构错了。建议如下：select a.bookid,a.bookname,a.type,a.price,a.author,a.press,b.ydate (select * from borrow where stat=1) from book a ,b where a.bookid = b.bookid 不过也是跟数据库的类型有关。

 

P

power255

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #6

改为另一种写法??select a.bookid, a.bookname, a.type, a.price, a.author, a.press, b.ydate from book a, borrow b where a.bookid = b.bookid and b.stat = 1

 

S

songrun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #7

1樓可解

 

灵

灵韵

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #8

我在oracle试了一下，把as去了就可以用了。

 

H

hedadt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-12-07

• #9

接受答案了.