SQL help

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF690D.FC6A3B58 Content-Type: text/plain; charset="iso-8859-1" Back again one more time. My dilemma, I have two tables, say table-p is parent and table-c is child. table-p: pkey, pdata table-c: ckey, pkey, cdata I need to create a third table table-3: 3key, pkey, all-cdata where field all-cdata is a concatenation of all cdata values for a specific pkey like all-cdata='cdata:cdata:cdata:...' etc. Is this possible with SQL? ------_=_NextPart_001_01BF690D.FC6A3B58 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12"> <TITLE>SQL help</TITLE> </HEAD> <BODY> <P><FONT SIZE=2 FACE="Arial">Back again one more time.</FONT> <BR><FONT SIZE=2 FACE="Arial">My dilemma, I have two tables, say table-p is parent and table-c is child.</FONT> </P> <P><FONT SIZE=2 FACE="Arial">table-p: pkey, pdata</FONT> </P> <P><FONT SIZE=2 FACE="Arial">table-c: ckey, pkey, cdata</FONT> </P> <P><FONT SIZE=2 FACE="Arial">I need to create a third table</FONT> </P> <P><FONT SIZE=2 FACE="Arial">table-3: 3key, pkey, all-cdata</FONT> </P> <P><FONT SIZE=2 FACE="Arial">where field all-cdata is a concatenation of all cdata values for a specific pkey</FONT> <BR><FONT SIZE=2 FACE="Arial">like all-cdata='cdata:cdata:cdata:...' etc.</FONT> <BR><FONT SIZE=2 FACE="Arial">Is this possible with SQL?</FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01BF690D.FC6A3B58--