> I have a table with two fields defining range of ids of another table,
> > IdFrom and IdTo. I would like to use this information (multiply rows as > a > > SELECT result of this IdFrom and IdTo) in joins. > > Something like this? > > select * from MyTable join Ranges > on (MyTable.id between IdFrom and IdTo); > Yes, thanks, Igor, Max _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
