use T23S001

select * from FINISHED_ITEM_MASTER


SELECT FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, SUM(BILL_ITEM_DETAIL.ItemPcs) AS ItemPcs, SUM(BILL_ITEM_DETAIL.ItemMts) AS ItemMts, MONTH(BILL_DETAIL.BillDate) AS Expr1 FROM BILL_ITEM_DETAIL INNER JOIN FINISHED_ITEM_MASTER ON FINISHED_ITEM_MASTER.ItemName = BILL_ITEM_DETAIL.ItemName INNER JOIN BILL_DETAIL ON BILL_ITEM_DETAIL.BillNo = BILL_DETAIL.BillNo GROUP BY FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, MONTH(BILL_DETAIL.BillDate) HAVING (FINISHED_ITEM_MASTER.DescGST = 'VELVET FABRICS') AND (MONTH(BILL_DETAIL.BillDate) = 9)


SELECT     FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPcs) AS ItemPcs, 
                      SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkMts) AS ItemMts, RECEIVED_RETURN_GOODS_DETAIL.BkGRDate
FROM         FINISHED_ITEM_MASTER INNER JOIN
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL ON FINISHED_ITEM_MASTER.ItemName = RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkItemName INNER JOIN
                      RECEIVED_RETURN_GOODS_DETAIL ON RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_DETAIL.BkSrNo
GROUP BY FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, RECEIVED_RETURN_GOODS_DETAIL.BkGRDate
HAVING      (FINISHED_ITEM_MASTER.DescGST = '(VELVET FABRICS') AND (RECEIVED_RETURN_GOODS_DETAIL.BkGRDate = 9)


SELECT     RECEIVED_RETURN_GOODS_DETAIL.BkSrNo, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode, SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPcs) AS Expr2, 
                      MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate) AS Expr1, RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode
FROM         RECEIVED_RETURN_GOODS_DETAIL INNER JOIN
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL ON RECEIVED_RETURN_GOODS_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo
GROUP BY RECEIVED_RETURN_GOODS_DETAIL.BkSrNo, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode, MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate), 
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode
HAVING      (MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate) = 9)

SELECT     SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkMts) AS Expr1
FROM         RECEIVED_RETURN_GOODS_ITEM_DETAIL INNER JOIN
                      RECEIVED_RETURN_GOODS_DETAIL ON RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_DETAIL.BkSrNo
WHERE     (RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode = '580137') AND (LEN(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo) = 6) AND 
                      (RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPer = 'M')
GROUP BY MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate)
HAVING      (MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate) = 9)





SELECT     MONTH(MULTI_JOURNAL_ADDLESS_DETAIL.JVDate) AS Expr1, MULTI_JOURNAL_ADDLESS_DETAIL.HSNCode
FROM         MULTI_JOURNAL_ADDLESS_DETAIL INNER JOIN
                      MULTI_JOURNAL_DETAIL ON MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo = MULTI_JOURNAL_DETAIL.BkSrNo
WHERE     (MONTH(MULTI_JOURNAL_ADDLESS_DETAIL.JVDate) = 9) AND (MULTI_JOURNAL_ADDLESS_DETAIL.HSNCode = '580137')