存储过程出错！

[哈哈哈啊002]

@dfid int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here

select dbo.tb_drugfactory.*,(select ID as 'OrganID',Name as "OrganName" from dbo.tb_organization
where RegionID=dbo.tb_drugfactory.RegionID)
from dbo.tb_drugfactory
where ID=@dfid
END

提示出错：
当没有用 EXISTS 引入子查询时，在选择列表中只能指定一个表达式。
我知道可以将两个表做联接来解决，但是有没有别的方法比联接更好的！

[jinjazz]

select top 1 ID

[tim_spac]

@dfid   int
AS
BEGIN
--   SET   NOCOUNT   ON   added   to   prevent   extra   result   sets   from
--   interfering   with   SELECT   statements.
SET   NOCOUNT   ON;

        --   Insert   statements   for   procedure   here

        select   dbo.tb_drugfactory.*,b.ID as 'OrganID',b.Name as "OrganName"     
        from dbo.tb_drugfactory   a
        join dbo.tb_organization  b on b.RegionID=a.RegionID
        where         ID=@dfid
END

[wzy_love_sly]

用楼上，你那个不行