Hi, you want this:
select * from Jobs where rec in (1, 2) Martin 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