I am using a database that is produced in Oracle and utilized in a GIS-software through SDE. Among my colleuges will make some statistics using this database and I am incompetent at getting a reasonable SQL-query to get the information.

I've two tables, one with sign ups and something with registrationdetails. It is a someone to many relationship, therefore the registration might have a number of particulars attached to it (no most).

  1. table: Registration

RegistrationID          Date       TotLenght

1                    01.01.2010        5

2                    01.02.2010        15

3                    05.02.2009        10

2.table: RegistrationDetail


DetailID     RegistrationID   Owner      Type      Distance

1                  1           TD          UB          1,5

2                  1           AB          US          2

3                  1           TD          UQ          4

4                  2           AB          UQ         13

5                  2           AB          UR         13,1

6                  3           TD          US          5

I would like the resulting selection to become something similar to this:


RegistrationID          Date       TotLenght DetailID     RegistrationID   Owner     Type      Distance  DetailID     RegistrationID   Owner      Type      Distance  DetailID     RegistrationID   Owner      Type      Distance

1                    01.01.2010        5         1              1           TD        UB          1,5          2               1          AB        US          2         3                  1              TD          UQ          4

2                    01.02.2010        15        4              2           AB        UQ         13            5               2          AB        UR         13,1

3                    05.02.2009        10        6              3           TD        US          5

Having a normal join I recieve one row per each registration and detail. Can anybody assist me to with this particular? I do not have administrator-privileges for that database, and so i can't create any tables or variables. Whether it's possible, I possibly could copy the tables into Access.

You cannot have multiple posts with similar title within the same query - oracle will relabel them as 'Date_1', 'Date_2' etc. What's wrong with getting several rows? How's it going being able to access it?