Re: New join type ?

On Tue, 19 Mar 2002 14:12:33 +0100, "Jan Hidders" <hidders_at_uia.ua.ac.be> wrote:
>If that doesn't work try helping
>the poor thing a little by telling it that it is actually a UNION that you
>want: :-)
>
>SELECT *
>FROM table1.col1, table2.col1
>WHERE NOT ( table1.col1 = 0) AND (table1.col1 = table2.col1);
>
>UNION
>
>SELECT *
>FROM table1.col1, table2.col1
>WHERE table1.col1 = 0 OR table1.col1 IS NULL;

I presume there are actually other criteria to deal with as well.

It might even be the case that table1 should be split into two types, those that have the appropriate fk, and those that don't. Or not.

J. Received on Mon Mar 25 2002 - 18:46:43 CET