kemaren

select a.*
from tr_product_store a
inner join tr_product_supplier b on (a.i_product=b.i_product)
where
(upper(a.i_product) like '%$cari%' or upper(a.e_product_name) like '%$cari%')
and a.i_store in(select i_store from tm_user_storex where i_user='$iuser')
and a.i_product in(select i_product from tr_product_satuan)
order by a.i_product

select a.*
from tr_product_bom a
left join tr_product_supplier b on(a.i_product=b.i_product)
where b.i_product_type in('24','26','24','26','41','45','47','52','93','B5','B7','B8','B9','C1')