求一条sql语句，难死我了。

[goodsgy]

article表字段：

articleid
title
content
typeid

types表字段：

typeid
typdname
itemid

itmes表字段：

itemid
itemname
groupid

groups表字段：

groupid
groupname

他们之间的关系是groups----items是一对多，items----types是一对多，types----article是一对多。
我想求一个sql语句联合这几个表查询出一个表
包括所有的article中的字段和以下字段
typeid
typename
itemid
itemname
groupid
groupname

不知道怎样写。

[goodsgy]

终于成功了，谢谢大家，应该是：
SELECT article.*, types.typename AS typename, types.itemid AS itemid, items.itemname AS itemname, items.groupid AS groupid, groups.groupname AS groupname FROM article INNER JOIN (types INNER JOIN (items INNER JOIN groups ON items.groupid = groups.groupid ) ON types.itemid = items.itemid) ON article.typeid = types.typeid;

[rexsp]

大概思路就是这样子的：
SELECT A.*,B.TypeName,B.ItemID,C.ItemName,C.GroupID,D.GroupName
FROM Article A
LEFT JOIN Types B ON A.TypeID=B.TypeID
LEFT JOIN Items C ON B.ItemID=C.ItemID
LEFT JOIN Groups D ON C.GroupID=D.GroupID
WHERE A.ArticleID=xxx

[bananasmiling]

sql="select t1.articleid,t1.title,t1.content,t1.typeid,t2.typeid,t2.typdname,t2.itemid
,t3.itemid,t3.itemname,t3.groupid,t4.groupid,t4.groupname from article t1,types t2,itmes t3,groups t4 where t1.typeid=t2.typeid and t2.itemid=t3.itemid and t3.groupid=t4.groupid"

[fangpeng2003]

SELECT dbo.article.*, dbo.types.typeid AS Expr1, dbo.types.typdname AS Expr2,
dbo.items.itemid AS Expr3, dbo.items.itemname AS Expr4,
dbo.groups.groupid AS Expr5, dbo.groups.groupname AS Expr6
FROM dbo.items INNER JOIN
dbo.groups ON dbo.items.groupid = dbo.groups.groupid INNER JOIN
dbo.types ON dbo.items.itemid = dbo.types.itemid INNER JOIN
dbo.article ON dbo.types.typeid = dbo.article.typeid

如果是access,把dbo.去掉

[guapollo]

select a.*,t.typeid,t.typename,i.itemid,i.itemname,g.groupid,g.groupname
from groups g,items i,types t,article a
where
a.typeid=t.typeid
and i.itemid=t.itemid
and g.groupid=i.groupid

[fangpeng2003]

SELECT article.*, types.typeid AS typeid, types.typename AS typename,
items.itemid AS itemid, items.itemname AS itemname,
groups.groupid AS groupid, groups.groupname AS groupname
FROM items INNER JOIN
groups ON items.groupid = groups.groupid INNER JOIN
types ON items.itemid = types.itemid INNER JOIN
article ON types.typeid = article.typeid

[fangpeng2003]

更正一下
SELECT article.*, types.typeid AS typeid, types.typename AS typename,
items.itemid AS itemid, items.itemname AS itemname,
groups.groupid AS groupid5, groups.groupname AS groupname
FROM article INNER JOIN
types ON article.typeid = types.typeid INNER JOIN
items ON types.itemid = items.itemid INNER JOIN
groups ON items.groupid = groups.groupid

[sunnyBelt]

Select groupname,Groups.groupid,itemname,items.itmeid,typename,types.typeid
from Groups inner join items on groups.groupid=items.groupid inner join types on itmes.itemid=types.itemid

[sunnyBelt]

Select groupname,Groups.groupid,itemname,items.itmeid,typename,types.typeid
from Groups inner join items on groups.groupid=items.groupid inner join types on itmes.itemid=types.itemid