Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> sql statement: join
Hallo,
a happy new year!
I have two tables:
table A with attribute A_ID (primary key) table B with attribute B_ID (primary key) and attribute A_ID (foreign key with A.A_ID == B.A_ID).
The relation between table A and table B is 1:n; n is VARIABLES in dependency of A_ID.
With "select A.A_ID, B.B_ID from A,B where A.A_ID == B.A_ID order by
A.A_ID, B.B_ID asc"
I get the following results in cursor:
(1) A_ID1, B_ID1
(2) A_ID1, B_ID2
(3) A_ID2, B_ID3
(4) A_ID2, B_ID4
(5) A_ID2, B_ID5
(6) A_ID3, B_ID6
...
Now I want to get the following results in cursor:
(1) A_ID1, num1, B_ID1, B_ID2
(2) A_ID2, num2, B_ID3, B_ID4, B_ID5
(3) A_ID3, num3, B_ID6
...
numX is the number of of keys B_ID.
How can I reslove this problem with ONE sql satement?
Thank you for your hints, Thomas Received on Wed Jan 08 2003 - 15:39:35 CST
![]() |
![]() |