How to apply "IN" operation on List.

How to apply "IN" operation on List.

  
Hi,

How to apply "IN" operation on List.
For example If i have 2 List and i want to check first List come values is present or not into second List of Record.
If you want much clarifications please let me know.

Thanks
Hitesh
Hi Hitesh,

First, questions like this are best posted in the Technology forum, which is the most active so the most people will see it. As for the "IN", aggregates cannot handle this, so you'll need an Advanced Query. In SQL, to do what you want you need a subquery in the WHERE clause.