Don't search "the net," just read DBIC's CPAN documentation. For example, in
http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Intro.pod is an example that uses "IN".
Update: Also, is your resultset really named "table1"? Where have you got that code from that you're trying? What is the error?
Ordinary morality is for ordinary people. -- Aleister Crowley