Re: A complex relationship

From: Nis Jorgensen <>
Date: Wed, 15 May 2002 16:55:17 +0200
Message-ID: <>

On 15 May 2002 07:46:28 -0700, (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, FROM RunProfile INNER JOIN MapProfileGroup USING gid

Nis Jorgensen

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

Original text of this message