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).
- table: Registration
RegistrationID Date TotLenght 1 01.01.2010 5 2 01.02.2010 15 3 05.02.2009 10
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?