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