"Martin Engelschalk", on Friday, May 20, 2011 9:04 AM wrote...
> Hi, > > you want this: > > select * from Jobs where rec in (1, 2) > > Martin Darn it! Thanks. And that is easier... :-) > Am 20.05.2011 15:00, schrieb jose isaias cabrera: >> Greetings. >> >> I would like to get a bunch of records of IDs that I already know. For >> example, this table called Jobs, >> rec,...,data,... >> 1,...,aaa,... >> 2,...,zzz,... >> ... >> ... >> 99,...,azz,... >> >> I know I can do this call, >> >> begin; >> select * from Jobs where rec=1; >> select * from Jobs where rec=2; >> end; >> >> and that would get me the records, but is there an easier way? I tried, >> >> select * from Jobs where rec=1, rec=2; >> >> and I only get the first one in the list. >> >> thanks for the help. >> >> josé >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
