Select returns one row from two

[Rocky XXVIII]

Goodmorning,
Could I have a SELECT statement that normally returns two rows
,but that instead returns one row appending to the first row the second
one of the result ?
For example

Query: "SELECT username from tab1 where year in (2001,2002)"

Result:
1° - "'John'"
2° - "'Adam'"

Instead I need:

Result:
"'John','Adam'"?

I have Win2000 Pro , SqlServer2000.

Thank You

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

[BSShadow]

"Rocky XXVIII" <al*******@hotmail.com> wrote in message news:<1c*************************************@myga te.mailgate.org>...

Goodmorning,
Could I have a SELECT statement that normally returns two rows
,but that instead returns one row appending to the first row the second
one of the result ?
For example

Query: "SELECT username from tab1 where year in (2001,2002)"

Result:
1° - "'John'"
2° - "'Adam'"

Instead I need:

Result:
"'John','Adam'"?

I have Win2000 Pro , SqlServer2000.

Thank You

You could do this:

SELECT a.username & ',' & b.username from tab1 a, tab1 b where a.year
=2001 and b.year = 2002;

Could add ' as needed or trims.

[Ross Presser]

On Tue, 12 Oct 2004 08:58:29 +0000 (UTC), Rocky XXVIII wrote:

Goodmorning,
Could I have a SELECT statement that normally returns two rows
,but that instead returns one row appending to the first row the second
one of the result ?
For example

Query: "SELECT username from tab1 where year in (2001,2002)"

Result:
1° - "'John'"
2° - "'Adam'"

Instead I need:

Result:
"'John','Adam'"?

I have Win2000 Pro , SqlServer2000.

This is the best you can do:

SELECT
(SELECT username from tabl where year = 2001) AS [user_2001],
(SELECT username from tabl where year = 2002) AS [user_2002]

[Rocky XXVIII]

"Ross Presser" <rp******@imtek.com> wrote in message
news:m8***************@rpresser.invalid

This is the best you can do:

SELECT
(SELECT username from tabl where year = 2001) AS [user_2001],
(SELECT username from tabl where year = 2002) AS [user_2002]

Very cool !!
I think you must be a SqlServer creator ... ;-)))
Thank Everybody

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG