Re: Conjunction junction
From: Gene Wirchenko <genew_at_mail.ocis.net>
Date: Mon, 01 Nov 2004 22:31:09 -0800
Message-ID: <vhsdo09kuhal4ddtul15nm4gg9b8d0g4ak_at_4ax.com>
Date: Mon, 01 Nov 2004 22:31:09 -0800
Message-ID: <vhsdo09kuhal4ddtul15nm4gg9b8d0g4ak_at_4ax.com>
"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote:
>"Laconic2" <laconic2_at_comcast.net> wrote in message
>news:JoWdnSRsGMlg8xvcRVn-3w_at_comcast.com...
>> select * from blocks
>> where
>> (color = 'RED') <> (shape = 'SQUARE')
>
>It certainly doesn't not work in SQL DBMS I use. Which products allow this
>syntax?
Visual FoxPro does. I have never needed such semantics in an SQL statement.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences. You have biases. He/She has prejudices.Received on Tue Nov 02 2004 - 07:31:09 CET