34,838
社区成员




@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