CodingForums.com - View Single Post - ORACLE: sub-query into delimited list?

Fou-Lu · 12-06-2012, 07:41 PM

Code:

+--------------+             +-----------------------+           +----------------+
| Developer    |             | ProjectDeveloper      |           | Project        |
+--------------+             +-----------------------+           +----------------+
| devid [PK]   |>+---------o<| projectid [PK][FK]    |>o-------+<| projectid [PK] |
+--------------+             | devid [PK][FK]        |           +----------------+
                             +-----------------------+

Simple as that. Associate two objects together in a manner which one relates directly to the other to create a valid tuple, and you have a many to many relation. Now you can join both project and developer against the projectdeveloper to get information from either or both.

12-06-2012, 07:41 PM	PM User \| #4
Fou-Lu God Emperor Join Date: Sep 2002 Location: Saskatoon, Saskatchewan Posts: 15,741 Thanks: 4 Thanked 2,465 Times in 2,434 Posts	Code: +--------------+ +-----------------------+ +----------------+ \| Developer \| \| ProjectDeveloper \| \| Project \| +--------------+ +-----------------------+ +----------------+ \| devid [PK] \|>+---------o<\| projectid [PK][FK] \|>o-------+<\| projectid [PK] \| +--------------+ \| devid [PK][FK] \| +----------------+ +-----------------------+ Simple as that. Associate two objects together in a manner which one relates directly to the other to create a valid tuple, and you have a many to many relation. Now you can join both project and developer against the projectdeveloper to get information from either or both.