Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
SELECT o.orderID, o.invoiceID, o.customerID, c.firstname + ' ' + c.lastname AS Name, o.invoiceDate, o.PayDate, o.ocr, o.orderDate, ISNULL(paymentStatusID, 0) AS paymentStatusID, o.paymentTypeID, orderStatusID, ISNULL(printed,0) AS printed, currencyID, paymentType, shipmentType, IsNull(sentOrder, 0) AS sentOrder FROM orders AS o INNER JOIN Customer AS c ON o.customerID = c.CustomerID INNER JOIN bklShipmentType AS bst ON bst.shipmentTypeID = o.shipmentTypeID INNER JOIN bklPaymentType AS bpt ON bpt.paymentTypeID = o.paymentTypeID WHERE (o.invoiceID > '0') AND (o.orgID = 11) AND orderSaved = 1 AND orderTypeID = 1 AND orderStatusID NOT IN (5, 8) AND o.paymentTypeID <> 12 ORDER BY orderDate DESC
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.