Thanks. I was afraid of that. I got out my old Data Base Systems books
and was trying to figure out what I forgot. Turns out I didn't forget it.
It's just not possible.
Thanks again. Off to coding.
On Thu, Nov 3, 2011 at 9:08 PM, Pavel Ivanov <paiva...@gmail.com> wrote:
> > What I ultimately want to do is iterate through a table that contains
> the> limit and use that value to select all matching values from another
> table,> limiting the number of records selected from the group to that
> defined by> limit.
> There's no way to do such thing using only SQL. You have to select
> data from your table of limits into your programming language, iterate
> through results and for each row issue separate select statement with
> appropriate limit (which will be a constant not a nested select
> On Thu, Nov 3, 2011 at 5:23 PM, Don V Nielsen <donvniel...@gmail.com>
> > Given the following, I get an error that f.zip does not exist.
> > I am mentally missing something contextually, but I'm not getting it.
> > Would someone work through the scope of things in this select.
> > select p.*,pr.rowid from pool_wi as p
> > inner join add_priorities as pr on pr.prty = p.prty
> > where p.zip = '53005' and p.crrt = 'C022'
> > order by pr.rowid
> > limit (
> > select f.need from seg_02_final_view as f where f.zip = p.zip and f.crrt
> > = p.crrt
> > )
> > What I ultimately want to do is iterate through a table that contains the
> > limit and use that value to select all matching values from another
> > limiting the number of records selected from the group to that defined by
> > limit. For example, a table would hold two rows of zip, route and limit,
> > [53005,C020,1] & [53005,C022,2]. I want to use the zip and route to
> > all matching records from another table, but limit the result of the
> > sub-select to the qty of records as defined by limit.
> > Thanks for your time and consideration.
> > dvn
> > _______________________________________________
> > sqlite-users mailing list
> > firstname.lastname@example.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> sqlite-users mailing list
sqlite-users mailing list