IN
Syntax
valuet IN (value1 AND value2 . . . .) or valuet IN subquery
Parameters
The first form permits using a list of values instead of a subquery.
The second form uses a subquery that is evaluated to produce an intermediate result, against which further processing can be performed.
Description
The IN predicate lets you use a list of values instead of a subquery, or will introduce a subquery.
*
*
This macro is available in IBM® Unica® Interact.
*
When using IN in IBM® Unica® Interact, you can only use the value IN (value1 AND value2 . . . .) syntax.
Examples
Creates a new column named TEMP containing the value one.
Creates a new column named TEMP containing all ones.
Creates a new column named TEMP, where each value is a one if the corresponding row of column V1 contains a value in column V2, else a zero.
Examples
SELECT title, current_rental_price FROM movie_titles WHERE our_cost IN (14.95, 24.95, 29.95 ) ;
UPDATE movie_titles SET current_rental_price = (regular_rental_price * .9) WHERE title IN ( SELECT movie_title FROM movie_stars WHERE actor_last_name = 'Stewart' AND actor_first_name = 'James' ) ;