All,
Please help.I have been trying but can't find an answer. In SQLIte, I have 2 tables, one is for a list of Projects (about 50 projects) and the other is a list of key dates for each project. Each project has about 20 key dates. How can run a query that will only return the top/first 5 dates for each project in one query. What I am trying to do is get a query that will only return 250 items (ie 50 projects by 5 key dates) max as I am showing these on a report but space is limited. Thanks, Rory _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users