Can someone help me with this? Suppose you have a Table/Recordset that has these columns: Date (string) Color (string) Offset (long) I want to extract from this Table/Recordset 40 contiguous records from 15 locations within the dataset, each referenced by the Date. For example, say I have 15 Dates already extracted by a previous query. I need to now get the 40 records that start at each of those 15 Dates. ================ Suppose my 15 Dates are: 2009-03-03 2008-11-05 2008-07-10 ... ... 2007-07-23 Assuming this is a SORTED dataset in ascending order by Date, I would need to extract 40 records that start with the record at 2009-03-03, then 40 records starting with the record at 2008-11-05, and so-forth. Can I do this in one SQL statement and have it produce one Recordset of this result? Or would I have to run 15 different queries? (PS: The columns I wish to return from those records are Date, Points1 only). Thank you!
Rick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
