多表查询的问题

[sonic18]

我有表download和表xh
享查询表download的字段software = 表xh的字段xh 的记录

在论坛上也找了些，都试了，就是不行

sql="select download.software,xh.xh from download as download,xh as xh where download.software=xh.xh"

出现错误：
Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft VBScript 运行时错误 错误 '800a01c2'

错误的参数个数或无效的参数属性值

大家帮帮忙啊

[hbhbhbhbhb1021]

sql="select download.software,xh.xh from download as download,xh as xh where download.software=xh.xh"
字段和表名不要一样，不能都用xh

[hsman]

up

[sonic18]

以上的都不行啊，为什么啊？我有的是access的数据库，（最讨厌access）

[sonic18]

谢谢大家，已经成功。

[mayi545]

试试这个行不行

sql="Select U.software C.xh From download As U inner join xh As C on U.software=C.xh "

[笨笨兔兔兔兔兔]

select * from download inner join xh on download.software=xh.xh

[jzywh]

sql="select download.software,(select xh.xh from xh where xh.xh=download.software) from download"