select @RecordCount= isnull(count(*),0),a.User_IDS,a.User_nameS,a.User_homePhone,a.User_cardId,a.User_phone
 from tb_User as a  @str   GROUP BY a.User_IDS,a.User_nameS,a.User_homePhone,a.User_cardId,a.User_phone
请问 @str 该怎么和上面的连接在一起
在线===  好心人帮帮

set @str='  join tb_intent as b on b.User_IDS=a.User_IDS   where  
   [email=a.house_ID=]a.house_ID='''+@User_nmes[/email]+ ''''

不好意识我贴错地方了
做的头晕了 真的不好意识 各位

SQL?