Hi, 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. So ideally it would be great to find a way to use them in joins directly, but if it's not possible, at least to find an effective way to populate this ranges to a temporary table. I know there's a always a way to do this algorithmically, but just wondering if it's possible with sql.
Thanks, Max Vlasov maxerist.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users