select sum(igstamt), sum(cgstamt), sum(sgstamt) from bill_item_detail where billno in (select billno from bill_detail where month(billdate)=1)

select sum(igstamt), sum(cgstamt), sum(sgstamt)  from RECEIVED_RETURN_GOODS_ITEM_DETAIL where BkSrNo in (select BkSrNo from received_return_goods_detail where month(bkgrdate)=1 and LEN(BkSrNo)=6)

SELECT     SUM(MULTI_JOURNAL_ADDLESS_DETAIL.IGSTAmt) AS Expr1, SUM(MULTI_JOURNAL_ADDLESS_DETAIL.CGSTAmt) AS Expr2, 
                      SUM(MULTI_JOURNAL_ADDLESS_DETAIL.SGSTAmt) AS Expr3, MULTI_JOURNAL_DETAIL.GSTSupplyType, MULTI_JOURNAL_DETAIL.JVType
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) = 1) AND (LEN(MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo) = 6)
GROUP BY MULTI_JOURNAL_DETAIL.GSTSupplyType, MULTI_JOURNAL_DETAIL.JVType

select sum(igstamt), sum(cgstamt), sum(sgstamt) from bill_item_detail where billno in (select billno from bill_detail where month(billdate)=1)


SELECT * FROM OPENING_BILL_DETAIL WHERE GSTAMT<>0

SELECT * FROM RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE BkBillNo NOT IN (SELECT BillNo FROM BILL_DETAIL UNION SELECT BillNo FROM OPENING_BILL_DETAIL) AND BkBillNo<>'' 

SELECT * FROM multi_journal_addless_detail WHERE (IGSTAmt=0 AND CGSTAmt=0) and len(bksrno) = 6 and month(JVDate)=1
SELECT * FROM bill_item_detail WHERE (IGSTAmt=0 AND CGSTAmt=0) or cgstamt<>sgstamt

select * from RECEIVED_RETURN_GOODS_ADDLESS_DETAIL where len(bksrno)=6 and bkbillno='028454/S'





SELECT * FROM TblGSTR_KING WHERE TotalValue+TaxableValue+IGSTAmt+CGSTAmt+SGSTAmt= 0





SELECT * FROM TblGSTR_KINGDATA WHERE HSN='58071090'