Given the following, I get an error that f.zip does not exist. Obviously, 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 table, 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 select 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
