怎么把这个两条语句合起来

如何把这个两条语句合起来

1.select   CreateID，code，name，CreateDate   from   usertab   where   code=001

2.SELECT   name   as   Createname   FROM   usertab   where   code=CreateID

usertab结构如下：

ID,     Code,   Name,   CreateID,   CreateDate

ID   自动编号

code   用户编号

name   用户名称

CreateID   记录创建者ID

CreateDate   记录创建时间

ID,     Code,   Name,   CreateID,   CreateDate

1，001，name1，002，2007-1-1

2，002，name2，003，2007-2-2

问题，我现在想查找出用户编号001的全部信息和记录创建者名称（注意是名称而不是创建者ID），用一条语句实现

select [ID],

CreateID，

code，

name，

CreateDate,

CreateName = (SELECT name

FROM usertab AS b

WHERE b.[ID] = a.CrateID)

from usertab AS a

where code=001




–用子查询

select [ID],

CreateID,

code,

name,

CreateDate,

(SELECT name

FROM usertab AS b

WHERE b.[ID] = a.CrateID) as CreateName

from usertab AS a

where code=001

select CreateID，code，name，CreateDate,name as Createname from usertab where code=001 and code=CreateID group by CreateID,Createname;