这个语句错在哪，急死了,没分了 (10分)

W

webug

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-10

• #1

今有两个库c:/a.mdb,c:/b.mdb， 两库中有同名表tablea,请问下面这语句错在哪?提示from语句错?
select aa.gradeid from tablea in "c:/a.mdb" aa ,tablea in "c:/b.mdb" bb where aa.studentid=bb.studentid

并且如何用sql实现foxpro类似功能
sele 1
use a
index on id to aid
sele 2
use b
index on id to bid
set rela to id into a
repl all b.xxx with a.xxx

 

C

chenxz

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-10

• #2

下面的对吗？可能不对[8D]
select aa..tablea.gradeid from aa..tablea where aa.tablea.studentid = bb.tablea.studentid

 

Q

QuickSilver

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-10

• #3

select aa.gradeid
from (select * from tablea in "c:/a.mdb") aa,
(select * from tablea in "c:/b.mdb") bb
where aa.studentid=bb.studentid

 

W

webug

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-10

• #4

感谢QuickSilver的正确答案!
但如何用sql实现foxpro类似功能
sele 1
use a
index on id to aid
sele 2
use b
index on id to bid
set rela to id into a
repl all b.xxx with a.xxx

 

Q

QuickSilver

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-10

• #5

update a,b
set b.xxx=a.xxx
where a.id=b.id

 

Q

QuickSilver

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-11

• #6

抱歉，你发第二条消息的时候我刚好去吃饭了，呵
关于access交叉表函数，我也没使用过，我如果看会了
再去你的问题
“如何用sql语句实现纵表到横表的转换”里去答复。