Code: Select all
SELECT
TruckPlanningList.VBELN_VL, TruckPlanningList.ActivationDate, HostState.HostStateId, HostState.Name AS HostStateName
FROM
TruckPlanningList with(nolock)
INNER JOIN
HostState with(nolock) ON TruckPlanningList.HostStateId = HostState.HostStateId
order by
HostState.Name, TruckPlanningList.ActivationDate
Code: Select all
VBELN_VL ActivationDate HostStateId HostStateName
---------- ------------------------------------------------------ -------------------- --------------------------------------------------
ABCDE12346 2006-11-20 14:50:05.977 1 Active
ABCDE12345 NULL 0 Inactive
(2 row(s) affected)
Code: Select all
VBELN_VL ActivationDate HostStateId HostStateName
---------- ------------------------------------------------------ -------------------- --------------------------------------------------
ABCDE12345 NULL 0 Inactive
ABCDE12346 2006-11-20 14:50:05.977 1 Active
(2 row(s) affected)