这句插入 数据的sql语句提示有错误。请看看。(20分)

L

llz629

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-27

• #1

insert into tzbsl (adate,idigest,rquantity,cquantity) values &nbsp;select &nbsp; a.ddate,'9','8',<br> &nbsp; '6'<br> &nbsp; &nbsp;from rd &nbsp;a &nbsp;inner join rds b &nbsp;on a.vid=b.vid <br>提示错误：在关键字 'select' 附近有语法错误。

 

J

Johnny_du

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-27

• #2

INSERT INTO TZBSL(ADATE,IDIGEST,RQUANTITY,CQUANTITY) SELECT A.DDATE,'9','8','6' FROM RD A INNER JOIN RDS B ON A.VID=B.VID;

 

李

李翔鹏

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-27

• #3

插入语句两种格式：<br>１．insert into table values(field1,field2...) &nbsp; --一次只能插入一行数据<br>2.insert into table(field1,field2,...) select field1,field2... from table2　　－－一次可以插入多行数据

 

C

cnhotel

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-27

• #4

去掉Values