Watch some penguins on the livecam!
--Query 1 SELECT SUM(I.[QTYORDER]) FROM POPHEADER as I inner join POPDETAIL as P on I.PONUMBER = P.PONUMBER where I.[POLNESTA] not in (4,5,6) and P.[DOCDATE] >= '1/1/2014' and I.[ITEMNMBR] = '209822011' and I.POTYPE =1 --Query 2 SELECT SUM(QTYRECVD) AS QTY FROM INVOICE_TABLE where [DATERECD] >= '1/1/2014' and RCPTSOLD = 0 and [PONUMBER] = '07277' and [ITEMNMBR] = '209822011'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.