I have such SQL query wich inside has subselect statement --------------------------- Select A.[Type] , B.[Exception] , A.Item , A.Location , A.Date as A_Date
,( Select TOP 1 A1.Date From TableA as A1 Where A1.Date >A.Date and A1.[Type] = 1 and A1.Item = A.Item and B.Key2 = A.Location Order by A.Date asc ) as A1_Date
From TableA as A Left join TableB as B on B.Key1 = A.[User] Where A.[Type] = 7 ------------------------- The question is how to write this SQL subselect part in LOAD if my SQL query would be more simple like this ------------------------- Select A.[Type] , B.[Exception] , A.Item , A.Location , A.Date as A_Date From TableA as A Left join TableB as B on B.Key1 = A.[User] Where A.[Type] IN (1, 7) -------------------------
