CREATE TABLE [dbo].[PACKAGING_SYSTEM_RECORDS] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[StateID] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PACKAGING_SYSTEM_STATE] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PackageState] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[FlowOrder] [int] NOT NULL 
) ON [PRIMARY]
GO
[code]


The data in the tables is as follows:

[code]
INSERT INTO PACKAGING_SYSTEM_RECORDS (StateID) VALUES(7);
INSERT INTO PACKAGING_SYSTEM_STATE (PackageState, FlowOrder) VALUES ('Flow One', 1);
INSERT INTO PACKAGING_SYSTEM_STATE (PackageState, FlowOrder) VALUES ('Flow Two', 2);
INSERT INTO PACKAGING_SYSTEM_STATE (PackageState, FlowOrder) VALUES ('Flow Three', 3);
INSERT INTO PACKAGING_SYSTEM_STATE (PackageState, FlowOrder) VALUES ('Flow Four', 4);
INSERT INTO PACKAGING_SYSTEM_STATE (PackageState, FlowOrder) VALUES ('Flow Five', 5);
INSERT INTO PACKAGING_SYSTEM_STATE (PackageState, FlowOrder) VALUES ('Flow Six', 6);
INSERT INTO PACKAGING_SYSTEM_STATE (PackageState, FlowOrder) VALUES ('Flow Seven', 7);

select t1.ID, t1.PackageState, t1.FlowOrder
from packaging_system_state t1
inner join (SELECT     PACKAGING_SYSTEM_RECORDS.ID, PACKAGING_SYSTEM_STATE.FlowOrder
FROM         PACKAGING_SYSTEM_RECORDS INNER JOIN
                      PACKAGING_SYSTEM_STATE ON PACKAGING_SYSTEM_RECORDS.StateID = PACKAGING_SYSTEM_STATE.ID) t2 on t2.FlowOrder >=t1.FlowOrder
where t2.id = 363 and t1.FlowOrder < 7