declare @uid as varchar(10)
set @uid = 某用户select id from pt020 where id in (select id from pt010 where uid = @uid)
set @uid = 某用户select id from pt020 where id in (select id from pt010 where uid = @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]