SELECT CONVERT(CHAR(10), ord.OrderDate, 105) AS myDate,st.storeName,stf.foodName,orde.optionDetails,orde.qty,orde.amount,emp.name,emp.lastname,ord.orderID,st.storeID FROM Employee emp INNER JOIN OrderDetails orde ON emp.empID=orde.empID INNER JOIN Orders ord ON emp.empID=ord.empID AND orde.orderID=ord.orderID INNER JOIN StoreFood stf ON orde.storeFood_rkey=stf.rkey INNER JOIN Store st ON stf.storeID=st.storeID WHERE ord.orderDate=CONVERT(varchar, GETDATE(), 111) And st.storeID='" & storeID & "' ORDER BY ord.orderID DESC