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

[sevenhalo]

It'll make it really hard down the road when you need to add functionality. I guess you can cross that bridge when you get there.

This should work for you (mind you, I don't have your data model nd couldn't test it. You may need to make slight modifications):

SELECT * FROM Audit_Split WHERE Audit_Split.Tran_Number in 
	(SELECT Audit_Header.Tran_Number FROM Audit_Header WHERE Audit_Header.TranNumber 
	between Audit_Header.Tran_Number-1 AND Audit_Header.Tran_Number + Audit_Header.Item_Count-1

Edit: I changed it to use AND