Re: A complex relationship

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