Re: Enforcing Join condition

On Nov 15, 2007 7:32 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
>
> You want to have a "conditional" foreign key reference that checks
> against different tables depending on a "type" field, right?
>
> For complicated conditions like this, you could use a
> BEFORE INSERT trigger that throws an error when the condition
> is violated.

That we do. My query is to put a check on select queries to avoid
programmers not using all the necessary conditions.

Thanks and regards,
Ma Sivakumar


--
மா சிவகுமார்
எல்லோரும் எல்லாமும் பெற வேண்டும்
http://masivakumar.blogspot.com