Using "SOME" in a subselect

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 18 Dec 2008 10:12:10 -0700
Message-ID: <3c5f7820812180912m4839f4c0o592425f8dbfc35aa@mail.gmail.com>


I came across some code today that has the following: SELECT
.
.
.

WHERE
.
.
.

  AND p.refreshTimeStamp = SOME

        (SELECT
                MAX(pa.refreshTimeStamp)
         FROM pymt pa
         WHERE compid = '12345666'

Can anyone tell me what the " = SOME" portion of the code does? I've done some research, but can't find anything so far.

-- 
Sandy
Transzap, Inc.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 18 2008 - 11:12:10 CST

Original text of this message