i am assuming that datefrom and dateto are in tblDate table.
now try below code :
Create Proc ProcDate
as
Begin
Select
td.id , tod.OrderDetails , [REPLACE(CONVERT(VARCHAR(20),td.DATEFROM,106),' ','-') + ' TO ' + REPLACE(CONVERT(VARCHAR(20),td.DATETO,106),' ','-')] AS [TOTAL ORDER RANGE DATE]
FROM tblDate td INNER JOIN tblOrderDetails tod
ON td.id = tod.id
END