• Модуль: main
  • Путь к файлу: ~/bitrix/modules/main/classes/mysql/database.php
  • Класс: CDatabaseMysql
  • Вызов: CDatabaseMysql::PrepareUpdateJoin
public function PrepareUpdateJoin($strTableName, $arFields, $from, $where)
{
	$tables = $strTableName;
	foreach ($from as $join)
	{
		$tables .= "n  INNER JOIN " . $join[0] . ' ON ' . $join[1];
	}
	$fields = '';
	foreach ($arFields as $fieldName => $fieldValue)
	{
		$fields .= ($fields ? ",n  " : "") . $strTableName . '.' . $fieldName . '=' . $fieldValue;
	}
	$update = 'UPDATE ' . $tables . "n"
		. "SETn  " . $fields . "n"
		. ($where ? "nWHERE" . $where : "");
	return $update;
}