sql 两个表条件相同的字段拼接

效果图如下

将表1 的email字段和表2的email字段进行拼接成一条数据

具体实现功能如下

使用函数进行拼接

USE [ERP]
GO
/****** Object:  UserDefinedFunction [dbo].[GetEmailAddress]    Script Date: 12/26/2013 13:43:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  FUNCTION [dbo].[GetEmailAddress](@id int)
RETURNS varchar(max)
with schemabinding
AS
BEGIN
    DECLARE @values varchar(max)    
    SELECT @values = Isnull(@values + ',', '') + email FROM dbo.crm_customer_linkman WHERE mainid=@id--用逗号隔开
    RETURN @values
END