Ken wrote: > I'll take a stab at this. > > Each connection would have its own private memory database. > > Create an additional temp table id_list , Insert the user id set values into > this table. > > Then > INSERT INTO temptab tt SELECT mt.* FROM maintab mt, id_list > WHERE mt.id = idl.id ; > > Then delete the id_list table or drop it. >
It does help, Ken - it's what I was hoping to do and your email clears it for me! Thanks! I'll try this tomorrow and come back if there are more questions. Thanks guys for the help. Cheers, Mohit. 9/11/2008 | 3:59 AM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users