WHEREIN Function

Find the indices into an array where the values occur in a second array; keywords yield intersection, union, and complement

i = WHEREIN( a, b [,c] )

a An array.

b An array.

i The array of indices into a where the values occur in b; if there are no such indices then a scalar -1 is returned.

c - (Optional) The number of such indices.

j The array of indices into b where the values occur in a; if there are no such indices then -1 is returned.

Intersection The vector of elements common to both a and b; if there are no such elements then nothing is returned.

Union the vector of elements in either a or b.

A_Complement The array of indices into a where the values do not occur in b; if there are no such indices then -1 is returned.

B_Complement The array of indices into b where the values do not occur in a; if there are no such indices then -1 is returned.

PM, WHEREIN( [0,1,2,3,2], [0,0,4,2,5,5,6,0] )

WHERE