String query = "select pi.p_code, pi.brand_name, pi.p_group, pi.pack_s ,  pit.quantity,  " +
                    "pip.T_P, pip.S_P from product_info pi, product_info_price pip, package_items pit\n" +
                    " where pi.p_code in(\n" +
                    " select p_code from package_items where package_id in(\n" +
                    " select package_id from package_info where package_name like '" + packageName + "') )\n" +
                    " and pi.p_code = pip.p_code and pi.p_code = pit.p_code";