Hi experts,
Hope you can assist me. I am somewhat of a novice at creating SQL queries but have used the SQL Wizard to good effect in the past.
I have created the following SQL query which provides me with dates for the creation and closing of a PO. I want to add the name the name of the person responsible for generating the PO. However, I am getting error message - T0.UserSign could not be bound. Any ideas?
SELECT T0.[DocNum], T0.[DocDate] AS 'Doc. Date',T0.[DocStatus], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Quantity], T2.[DocDate] AS 'Closed Date', T3.[U_NAME] FROM OPOR T0 INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry], OPDN T2 INNER JOIN OUSR T3 ON T0.[UserSign] = T3.[USERID] WHERE T0.[DocDate] >= '[%1]' AND T0.[DocDate] <= '[%2]'