[vtk-developers] Intersecting tables

[Kerr, Robert]

I have a table, one column of which has the name "foo" which consists of a random set of numbers e.g. {1, 2, 3, 6, 7, 45, 344, etc.}.
I have another table (call it the selection), which has one column, whose entries are a subset of "foo" e.g. {1, 7, 344}.
Is there a quick and easy way to get the rows corresponding to the selection?  I know I can loop through one table and check for existence in the other table, but perhaps that's already been written somewhere and I'm just too dense to find it.

Thanks

-bob
Meddle not in the affairs of wizards, for they are subtle and
quick to anger.
**********************************************************************
   Robert Kerr,  Titan Informatics Toolkit Developer
   rakerr at sandia.gov         |    PO Box 5800,  MS 1323
   Phone: (505) 844-8606    |    Sandia National Labs
   Fax: (505) 284-2518        |  Albuquerque, NM 87185-1323
**********************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://public.kitware.com/pipermail/vtk-developers/attachments/20101012/ea72b0d5/attachment.html>