SHARE
TWEET

Untitled

a guest Jan 12th, 2017 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT INInvoiceHeaders.ordno
  2. FROM INInvoiceHeaders
  3. WHERE (MONTH(INInvoiceHeaders.invdate)=11  
  4.   AND YEAR(INInvoiceHeaders.invdate)=2016)
  5. UNION DISTINCT
  6. SELECT INArchivedInvoiceHeaders.ordno
  7. FROM INArchivedInvoiceHeaders
  8. WHERE (MONTH(INArchivedInvoiceHeaders.invdate)=11
  9.   AND YEAR(INArchivedInvoiceHeaders.invdate)=2016)
  10. GROUP BY ordno
RAW Paste Data
Top