同时从两个 SQL 语句查询？

问：

我有两个SQL查询：第一个查询从数据库中提取所有查询，第二个查询查找任何：criteriacriteria completed

SQL 查询 1

//get all criteria for section
$getcrit = $mysqli->prepare("SELECT id, category_id, section_name, criteria  
FROM prepare_criteria
WHERE category_id=? AND section_name=? ");
$getcrit->bind_param('is', $cat_id, $sectname);
$getcrit->bind_result($criteria_id, $category_id, $section_name, $criteria);
$getcrit->execute();
$getcrit->store_result();
$row_cnt = $getcrit->num_rows();
$getcrit->fetch();

SQL 查询 2

//get any checked criteria from db
$getcompcrit = $mysqli->prepare("SELECT prepare_criteria_complete.criteria_id, prepare_criteria.id, prepare_criteria.criteria, prepare_criteria_complete.business_id, prepare_criteria_complete.category_id 
FROM prepare_criteria_complete, prepare_criteria
WHERE business_id=?
AND prepare_criteria.id=prepare_criteria_complete.criteria_id");
$getcompcrit->bind_param('i', $business_id);
$getcompcrit->bind_result($cc_criteria_id, $criteria_completed_id, $comp_criteria, $business_id_db, $category_db);
$getcompcrit->execute();
$getcompcrit->store_result();
$gc_row_cnt = $getcompcrit->num_rows();

然后，我正在编写一个循环来检查任何：whilecriteria completed

if ($gc_row_cnt >=1)
{
    while ($getcompcrit->fetch() )
    {
        if ($cc_criteria_id==$criteria_completed_id)
        {
            echo $criteria_completed_id." ";    
        }
        if ($criteria_id!=$criteria_completed_id) 
        {
        echo $criteria_id." ";  
        }
    }
}

第二个未按预期运行。 我知道一定有一种更干净的方法可以做到这一点！ 也许是一份声明？ifJOIN