Click to See Complete Forum and Search --> : Please Help me


youngminister
May 28th, 2004, 10:05 PM
I am really beginner about SQL.

I can use simple SQL and using C with that simple quary data.
but I want to lean it. so please give me an example about this question.

My question is

SELECT DATA_I FROM TABLE_I
WHERE KEY_I = 'BBB'
AND KEY_II = 'AAA'

and the result is

A
B
C
D
E
F
G

and I want to make them Like this "A,B,C,D,E,F,G".

It means I want to merge from every "row" data.

I can read all and using C language but I want to know to do it without C language.

hspc
May 29th, 2004, 04:12 AM
What database do you use?
if you use MS SQL server for example you can store the query results in a temporoary table variable then use a cursor to conctinate the string ...
this is not possible in access.