Please help for below Query.
This query is run based on a date range and brings up details of quotes created.
(What I would like is the same report but based on the Last Updated Date and also add a field Last Updated By, it has a posting date which should be the same as date created could we have Last Updated Date as well?)
SELECT T1.[U_NAME]'Created BY',
FROM OQUT T0
INNER JOIN OUSR T1 ON T0.[UserSign] = T1.[USERID]
INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode]
WHERE T0.[DocDate] between [%0] and [%1]
Order by T1.u_name ,T0.docdate