Hassle-free live chat software re-imagined for business growth. 2 users, always free.
--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'
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!