SELECT OFFER_MASTER0001.offer_type,OFFER_MASTER0001.discount,OFFER_DETAILS0001.offer_itemcode, OFFER_DETAILS0001.offer_qty,OFFER_MASTER0001.item_code FROM OFFER_MASTER0001 LEFT OUTER JOIN OFFER_DETAILS0001 ON OFFER_MASTER0001.offer_no = OFFER_DETAILS0001.offer_no WHERE (OFFER_MASTER0001.item_code = '0000010') AND (OFFER_MASTER0001.qty = 2) AND (OFFER_MASTER0001.date_from < '06-Mar-15 11:27:38 AM' AND OFFER_MASTER0001.date_to > '06-Mar-15 11:27:38 AM')
WHERE (quantity%2) = 0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)