Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: A complex relationship

Re: A complex relationship

From: Nis Jorgensen <nis_at_dkik.dk>
Date: Wed, 15 May 2002 16:55:17 +0200
Message-ID: <1et4eu4gqjnhha12jitefq7i00nbsklue1@4ax.com>


On 15 May 2002 07:46:28 -0700, calvin_tai2000_at_yahoo.com.hk (Calvin Tai) wrote:

> Therefore AdCampaignRun may have a relation directly with a
>'Profile' OR it may have a relation with a 'ProfileGroup' (so as it
>have a transitive relation with a group of 'Profile').

This sounds like you should use a UNIONed view, something like

SELECT rid, pid FROM RunProfile

UNION DISTINCT SELECT RunProfile.rid, MapProfileGroup.pid FROM RunProfile INNER JOIN MapProfileGroup USING gid

-- 
Nis Jorgensen
Amsterdam

Please include only relevant quotes, and reply below the quoted text. Thanks
Received on Wed May 15 2002 - 09:55:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US