Max Vlasov wrote: > I doubt this is sqlite specific question, maybe sql in general. > 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); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
