Path: utzoo!mnetor!uunet!lll-winken!lll-tis!ames!oliveb!sun!yosemite!trogers
From: trogers%yosemite@Sun.COM (Tom Rogers)
Newsgroups: comp.databases
Subject: In clause in ANSI SQL
Message-ID: <49498@sun.uucp>
Date: 14 Apr 88 15:09:05 GMT
Sender: news@sun.uucp
Lines: 17
Keywords: IN SQL ANSI

>The equivalent SQL UPDATE syntax:
>
>(I can't remember for sure if the IN clause is Codd or ANSI standard,

The ANSI SQL IN predicate is defined as:

<in predicate> ::= <value expression> [NOT] IN {<subquery> | <in value list>}

<in value list> ::= <value specification> {,<value specification>}...

where <value expression> is

<value expression> ::= 
	<term>
	| <value expression> + <term>
        | <value expression> - <term>

etc....