- Joined
- Jul 22, 2008
- Messages
- 4
- Reaction score
- 0
hello there
I have a problem. I have a really simple table here:
table1 with three fields A, B and C.
The content of the table is:
a1, b1, c11
a1, b1, c12
a1, b1, c13
a2, b2, c21
a2, b2, c22
a2, b2, c23
A is primary key.
My question is: I need to build a query which will get these rows
a1, b1, c11/nc12/nc13
a2, b2, c21/nc22/nc23
from the content of the table1 that I mentioned.
Would you please suggest some way to build a select which would get these two rows?
I could think of a query which would look like something like this:
select A, B, T1.C,"/n",T2.C
from table1 as T1, table1 as T2
where T1.B = T2.B
but this not only does not solve my problem but it is my closest approach to a possible solution.
Thanks for your suggestions.
I have a problem. I have a really simple table here:
table1 with three fields A, B and C.
The content of the table is:
a1, b1, c11
a1, b1, c12
a1, b1, c13
a2, b2, c21
a2, b2, c22
a2, b2, c23
A is primary key.
My question is: I need to build a query which will get these rows
a1, b1, c11/nc12/nc13
a2, b2, c21/nc22/nc23
from the content of the table1 that I mentioned.
Would you please suggest some way to build a select which would get these two rows?
I could think of a query which would look like something like this:
select A, B, T1.C,"/n",T2.C
from table1 as T1, table1 as T2
where T1.B = T2.B
but this not only does not solve my problem but it is my closest approach to a possible solution.
Thanks for your suggestions.
Last edited: