求助：这样的存储过程怎么写？

[rivus]

表1（uid，username）
表2（sid，uid）
表3（gid，sid）

需求：给定username，首先在表1中找到uid，然后再通过uid在表2中找到sid,然后再通过sid在表3中找到gid

我想写在一个存储过程中
求助
谢谢

[zjcxc]

CREATE PROC dbo.p
	@username varchar(100)
AS
SELECT
	*
FROM 表1 A, 表2 B, 表3 C
WHERE A.uid = B.uid
	AND B.sid = C.sid
	AND A.username = @username
GO

[Garnett_KG]

CREATE PROC spT
   @UserName VARCHAR(100)
AS
   SELECT *
   FROM Table1 a JOIN Table2 b
           ON a.UID=b.UID
        INNER JOIN Table3 c
           ON b.SID=c.SID
   WHERE a.UserName=@UserName

[zjcxc]

根据实际需求, 把SELECT * 换成 SELECT 你需要显示的列的列表

[wzy_love_sly]

select c.gid from 表1 a join 表2 b on a.uid=b.uid 
join 表3 c on b.sid=c.sid
where a.username='值'

[jinjazz]

select gid from table3 inner join table2 on table3.sid=table2.sid
inner join table1 on table2.uid=table1.uid
where table1.username='jinjazz'

[水族杰纶]

create proc Test
@uid int
as
select t3.gid from ta t1 inner join tb t2 on t1.uid=t2.uid
inner join tc t3 on t2.sid=t3.sid
and t1.uid=@uid

[-狙击手-]

CREATE PROC dbo.p
@username varchar(100)
AS
SELECT c.gid
FROM 表1 A, 表2 B, 表3 C
WHERE A.uid = B.uid AND B.sid = C.sid AND A.username = @username
GO

[fcuandy]

select distinct c.* from t1 a
inner join t2 b
on a.uid=b.uid
inner join t3 c
on b.sid=c.sid
where a.username='值'