Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Conjunction junction

Re: Conjunction junction

From: Gene Wirchenko <genew_at_mail.ocis.net>
Date: Mon, 01 Nov 2004 22:31:09 -0800
Message-ID: <vhsdo09kuhal4ddtul15nm4gg9b8d0g4ak@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 - 00:31:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US