Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Question about selecting a table

2 posts in Appeon (partner product) Last posting was on 2005-09-08 01:32:14.0Z
Albert Posted on 2005-09-07 17:42:54.0Z
From: "Albert" <albert.wang@morganstanley.com>
Newsgroups: sybase.public.appeon
Organization: 199.89.64.178
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Question about selecting a table
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <431f269e$1@forums-1-dub>
Date: 7 Sep 2005 10:42:54 -0700
X-Trace: forums-1-dub 1126114974 64.79.161.40 (7 Sep 2005 10:42:54 -0700)
X-Original-Trace: 7 Sep 2005 10:42:54 -0700, web110.discountasp.net
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1121
Article PK: 12860

Hello, SQL experts,

I have a question about selecting a table, if you can give answers,
it'll be appreciated.

I have a table T1 like this :
T1
C1 C2
------------
1 abc
1 def
1 xyz
2 cdf
2 lmn
.....

I want to get results like this: (Concatenate "C2" with the same
column "C1")
-------------------
1 abcdefxyz
2 cdflmn
.....

If I DON'T want to use cursor, how can I use "select statement (or
with possible temporary table)" to get the result ?

Thank you very much

Albert

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Julie Jiang Posted on 2005-09-08 01:32:14.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <431f269e$1@forums-1-dub>
Subject: Re: Question about selecting a table
Lines: 105
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0136_01C5B458.17EE92C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 210.21.221.178
X-Original-NNTP-Posting-Host: 210.21.221.178
Message-ID: <431f949e@forums-1-dub>
Date: 7 Sep 2005 18:32:14 -0700
X-Trace: forums-1-dub 1126143134 210.21.221.178 (7 Sep 2005 18:32:14 -0700)
X-Original-Trace: 7 Sep 2005 18:32:14 -0700, 210.21.221.178
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1125
Article PK: 12861

Please post your question in the newsgroups that are related with SQL so some SQL expert can take good care of it ASAP.
 
Regards,
Julie
"Albert" <albert.wang@morganstanley.com> wrote in message news:431f269e$1@forums-1-dub...
Hello, SQL experts,

I have a question about selecting a table, if you can give answers,
it'll be appreciated.

I have a table T1 like this :
T1
C1       C2
------------
1        abc
1        def
1        xyz
2        cdf
2        lmn
.....

I want to get results like this: (Concatenate "C2" with the same
column "C1")
-------------------
1        abcdefxyz
2        cdflmn
.....

If I DON'T want to use cursor, how can I use "select statement (or
with possible temporary table)" to get the result ?

Thank you very much

Albert

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp