Форум

$strSQL="SEL ECT t1.PRODUCT_ID as ELEMENT_ID
FR OM b_catalog_price t1, b_catalog_price t2,  
WHERE t1.PRICE = t2.PRICE AND t1.PRODUCT_ID = t2.PRODUCT_ID AND t1.CATALOG_GROUP_ID = 1 AND t2.CATALOG_GROUP_ID =2";
$result = $DB->Query($strSQL);
while ($row = $result->Fetch())
{
   $arElementIDs[]=$row["ELEMENT_ID"];
}
$GLOBALS["arFilter"]=Array("ID"=>$arElementIDs);