Comments by spunnam (Top 2 by date)

Actually,I though that you want latest record irrespective of each customer.Thats why i used TOP(1),Which retrieves only one topest record.Try the following query for your requirement..
;WITH cte as
(
SELECT id,max(oSDate) AS latestStartDate
FROM tblOrder
group BY id
)

SELECT C.*,O.*
FROM tblCust AS C
LEFT JOIN tblOrder AS O on O.id =C.id
LEFT JOIN cte AS Temp on Temp.id = C.id
WHERE O.oSDate = Temp.latestStartDate