大家请帮忙看看这一小段SQL语句为何出错。谢谢

[WorldCreater]

大家请帮忙看看这一小段SQL语句为何出错。谢谢
错误提示：
服务器: 消息 107，级别 16，状态 2，行 1
列前缀 'accessrequ0_' 与查询中所用的表名或别名不匹配。

这是我从原完整SQL语句中分离出来的

select distinct accessrequ0_.REL_ID as x0_0_
from KYDA_ACCESS_REQUEST accessrequ0_, KYDA_USER_DETAILS userdetail1_
--如果去掉第二张表就不会出错
inner join KYDA_REQUEST_XFILE_BORROW setofreque6_ on accessrequ0_.REL_ID=setofreque6_.REQUEST_REL_ID
where
((userdetail1_.REL_ID=3 ))


===================================================
以下是完整的语句
------------------------------

select distinct accessrequ0_.REL_ID as x0_0_
from KYDA_ACCESS_REQUEST accessrequ0_, KYDA_USER_DETAILS userdetail1_

inner join KYDA_USER_GROUP_RELATION setofuserg2_ on userdetail1_.REL_ID=setofuserg2_.USER_REL_ID
inner join KYDA_UNIFORM_GROUP uniformgro3_ on setofuserg2_.GROUP_REL_ID=uniformgro3_.REL_ID
inner join KYDA_AUTHORITIES setofautho4_ on userdetail1_.REL_ID=setofautho4_.REL_ID
inner join KYDA_ROLE_DEFINIENS roledefini5_ on setofautho4_.AUTHORITY=roledefini5_.SYMBOL


inner join KYDA_REQUEST_XFILE_BORROW setofreque6_ on accessrequ0_.REL_ID=setofreque6_.REQUEST_REL_ID
inner join KYDA_XFILE xfile7_ on setofreque6_.XFILE_REL_ID=xfile7_.REL_ID
inner join KYDA_XOURCE xource8_ on xfile7_.REL_ID=xource8_.REL_ID
inner join KYDA_XOURCE_GROUP_RELATION setofxourc9_ on xource8_.REL_ID=setofxourc9_.XOURCE_REL_ID
inner join KYDA_UNIFORM_GROUP uniformgro10_ on setofxourc9_.GROUP_REL_ID=uniformgro10_.REL_ID
inner join KYDA_ACCESS_RULE_TACHE accessrule11_ on setofreque6_.NEXT_TACHE_REL_ID=accessrule11_.REL_ID
inner join KYDA_ROLE_DEFINIENS roledefini12_ on accessrule11_.ROLE_SYMBOL=roledefini12_.SYMBOL


where
((userdetail1_.REL_ID=3 ))

and((uniformgro3_.REL_ID=uniformgro10_.REL_ID ))
and((roledefini5_.SYMBOL=roledefini12_.SYMBOL ))

[WorldCreater]

上面的代码在 sql server 中执行出错，可是在 hsql 中正常的。
搞不懂错在哪。。。。。

[子陌红尘]

select
distinct accessrequ0_.REL_ID as x0_0_
from
KYDA_ACCESS_REQUEST accessrequ0_
cross join
KYDA_USER_DETAILS userdetail1_
inner join
KYDA_REQUEST_XFILE_BORROW setofreque6_
on
accessrequ0_.REL_ID=setofreque6_.REQUEST_REL_ID
where
userdetail1_.REL_ID=3

[WorldCreater]

晕。我好象发现问题了：

join 语句必须紧跟在相应的表后边。。。。。。。。。。
否则就出错

[WorldCreater]

cross 这好象是特有的关键字，有没有其它的方法。

使用标准的保留字，使之能运行于其它的数据库如 oracle等之上？