SQL PUNYA KARUNGAN GUDANG BESAR ACC SUKSES PERTAMA TAPI GAGAL KONSEP

---- ini baca semua haha
SELECT  a.i_product_parent AS i_product_group, a.e_product_name_group_parent AS e_product_name_group
FROM tr_product_stock_produksi a
LEFT JOIN tr_product_supplier b ON(b.i_product=a.i_product_parent)
LEFT JOIN tm_do_item c ON(c.i_product=a.i_product_parent)

WHERE b.i_product_type IN('A2')

AND a.i_product IN(SELECT i_product FROM tm_do_item
           WHERE  i_store='GA'
          )

AND  (( (c.i_product  NOT IN(SELECT i_product FROM tm_karungan_item
           WHERE i_product= c.i_product
           AND i_do=c.i_do)) OR (c.i_product  IN(SELECT i_product FROM tm_karungan_item
           WHERE i_product= c.i_product
           AND i_do=c.i_do) ) )
           AND (

    c.i_do  NOT IN(SELECT i_do FROM tm_karungan_item
           WHERE i_product= c.i_product
           AND i_do=c.i_do

           )
           )

    )

AND (UPPER(a.i_product_group) LIKE '%%' OR UPPER(a.e_product_name_group) LIKE '%%')
GROUP BY i_product_parent, e_product_name_group_parent


---- ini detail yang gagal haha
SELECT a.*, n_deliver AS qty
FROM tm_do_item a
LEFT JOIN tr_product_stock_produksi b ON(a.i_product = b.i_product)

WHERE i_store='GA'
AND ((( a.i_product NOT IN(SELECT i_product FROM tm_karungan_item
           WHERE i_product = a.i_product
           AND i_do = a.i_do
           )) OR
      (a.i_product IN(SELECT i_product FROM tm_karungan_item
           WHERE i_product = a.i_product
           AND i_do = a.i_do
           )))
    AND  (
    a.i_do NOT IN(SELECT i_do FROM tm_karungan_item
           WHERE i_product = a.i_product
           AND i_do= a.i_do )
    )
    )


AND b.i_product_parent = 'RING004PT'