hi My knowledge to sql is very limited. So forgive me if this sounds really simple to you. I want to do a lookup operation with sqlite: I have a table (id, value), where id is an index field, now I have a list of ids, and I want to retrieve their values from the database and separate them with ",".
I know I can do a loop: for each id, "select value from mydata where id='id_i'" then concatenate the values after the loop. I somehow felt that this will be very slow. I am wondering if there is a command can do this lookup more efficiently. thank you in advance Qianqian _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
