[comp.databases] In clause in ANSI SQL

trogers%yosemite@Sun.COM (Tom Rogers) (04/14/88)

>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....