有关多表查询的问题，请帮忙看看，急！！！ado+access2000(15分)

G

guyaling

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-11

• #1

procedure TForm1.BitBtn1Click(Sender: TObject);
begin
with adoquery1 do begin
close;
sql.clear;
sql.text:='select rktemp.bianh cpprint.no01 from rktemp1,cpprint where rktemp1.bianh=cpprint.bianh';
open;
end;

 

B

bluerain

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-11

• #2

sql.text:='select rktemp.bianh cpprint.no01 from rktemp1,cpprint where rktemp1.bianh=cpprint.bianh';
少个逗号吧,
sql.add('select rktemp.bianh, cpprint.no01 from rktemp1,cpprint where rktemp1.bianh=cpprint.bianh');

 

G

guyaling

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-11

• #3

是少了个逗号，但又出现'parameter rktemp.bianh has no default value' 错误提示；
还请帮忙！

 

B

bluerain

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-11

• #4

天哪,你的表是rktemp1,而select中写的是rktemp.bianh.
自己写sql的时候,检查得仔细一点.

 

X

xiaoyu_online

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-11

• #5

jion into !!!

 

G

guyaling

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-11

• #6

多谢bluerain，下次一定要仔细一点。问题解决了。

 

G

guyaling

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-11

• #7

多人接受答案了。