SELECT Orders.ST_ID, Orders.ORDER_NUMBER, Orders.FULL_NAME, Orders.ORDER_DATE
,SUM(DATEDIFF(d, DATEADD(d, -1, Orders.Order_date), GETDATE())) as num_days, Orders.INVOICE_NUMBER
From Orders INNER JOIN
Order_Lines ON Orders.ORDER_NUMBER = Order_Lines.ORDER_NUMBER
WHERE Order_Lines.PRODUCT_CODE IN ('EXAMPREP-V')
AND Orders.ORDER_NUMBER = '#FORM.access_code#'
AND Orders.STATUS NOT IN ('C','CT')
Group by Orders.ST_ID, Orders.ORDER_NUMBER, Orders.FULL_NAME, Orders.ORDER_DATE, Orders.INVOICE_NUMBER
ORDER BY Orders.ORDER_DATE DESC
SELECT ORDER_NUMBER, ORDER_TYPE_CODE
FROM Orders where INVOICE_NUMBER = '#getReg.INVOICE_NUMBER#'
AND ORDER_TYPE_CODE = 'RETURN'