多表联合查询如何实现????

[longshaoye]

现有pt010和pt020两张表:
pt010中字段有 uid(用户名),b_type(表类型),id(帖子主题号)
pt020中字段有 id(帖子主题号)............................
现做这样的查询,根据pt010中的uid去pt020中查询id的各种内容!
我现在做成这样了,但还没有实现根据uid去查询:
SELECT A.B_TYPE,B.[ID],B.TITLE ,DT_REG=CONVERT(CHAR(10) ,DT_REG , 120),B.REG_USER,B.YN_COMPLETE FROM PT010 AS A INNER JOIN PT020 AS B ON A.[ID]=B.[ID]

我怎么去实现根据pt010里的uid(@UID变量)去查询呢?

[dawugui]

declare @uid as varchar(10)
set @uid = 某用户

select id from pt020 where id in (select id from pt010 where uid = @uid)

[longshaoye]

要在存储过程里加入uid,也就是我上面写的那些话
SELECT A.B_TYPE,B.[ID],B.TITLE ,DT_REG=CONVERT(CHAR(10) ,DT_REG , 120),B.REG_USER,B.YN_COMPLETE FROM PT010 AS A INNER JOIN PT020 AS B ON A.[ID]=B.[ID]

[longshaoye]

顶!