[RESOLVED] SELECT x records from table using the Between command

[chilling]

Is it possible to create a SELECT command to show the Header_ID for each SPLIT record when the file structure is as follows:

Table HEADER
Header_ID (which is equal to the first Split_ID in the SPLIT table)
Split_Count
Amount_Total (total of the transaction's Amount_Split records in the SPLIT table)

Table SPLIT
Split_ID
Amount_Split

ie there is no field in the SPLIT table holding the HEADER.Header_ID.

A transaction consists of a HEADER record and a number of SPLIT records.
The SPLIT table Split_ID is an auto number and generatd sequentally.
The HEADER table hold the first Split_ID and the number of SPLIT records which make up the transaction.

ie If the next Split_ID ie 345 and the next transaction had three Split records and the next but one transaction had two Split reords the following records would be added to the two tables:

Table SPLIT
Split_ID
345
346
347

348
349


Table HEADER
Header_ID = 345, Split_Count = 3
Header_ID = 348, Split_Count = 2