SELECT pit.p_code, pro.brand_name, pro.p_group, pro.pack_s, pit.quantity, pip.T_P, pip.S_P, PI.PACKAGE_NAME  FROM package_info pi, package_items pit, product_info pro, product_info_price pip
 WHERE PI.PACKAGE_ID = PIT.PACKAGE_ID AND PI.PACKAGE_NAME LIKE '%Jul%'
 AND pro.p_code = pit.p_code AND pip.p_code = pit.p_code