Re: [sqlite] Id ranges to be used with joins

> 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

Re: [sqlite] Id ranges to be used with joins

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

[sqlite] Id ranges to be used with joins

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