Question

asp如何同时读取两个数据表?

asp+access.
数据库里有两个表:
club表两个字段:cid,cname
user表三个个字段:uid,uname,cid

要求查询出如下结果

用户编号(uid),用户名(uname),俱乐部名(cname)

如何写sql语句查询啊?

Answer 1

select a.uid,a.uname,b.cname from user as a,club as b where a.cid=b.cid

Answer 2

select uid,uname,cname
from club c,user u
where c.cif=u.cid;

Answer 3

select user.uid,user.uname,club.cname
from user,club
where user.cid=club.cid