select s.OrderNo,h.Fabric,h.MaterialUnit, s.IsCustomerUrgent,s.CuttingMember ,h.Technology,h.Quantity
from Orders s join OrdersCoats h on h.OrderID =s.OrderID
where s.OrderDate between '2015-10-01 14:33:29.802'and '2015-11-07 14:33:29.802' and s.OrderStatus ='90' and s.DeliveryDate <='2015-11-07 14:33:29.802' and s.OrderNo <>N'' and h.Technology <>N''
order by s.DeliveryDate desc
from Orders s join OrdersCoats h on h.OrderID =s.OrderID
where s.OrderDate between '2015-10-01 14:33:29.802'and '2015-11-07 14:33:29.802' and s.OrderStatus ='90' and s.DeliveryDate <='2015-11-07 14:33:29.802' and s.OrderNo <>N'' and h.Technology <>N''
order by s.DeliveryDate desc