MysqliSqlHelper::prepareCorrelatedUpdate

public function prepareCorrelatedUpdate($tableName, $tableAlias, $fields, $from, $where)
{
	$dml = "UPDATE " . $tableName . ' AS ' . $tableAlias . ",n";
	$dml .= $from . "n";

	$set = '';
	foreach ($fields as $fieldName => $fieldValue)
	{
		$set .= ($set ? ',' : '') . $tableAlias . '.' . $fieldName . ' = ' .$fieldValue . "n";
	}
	$dml .= 'SET ' . $set;
	$dml .= 'WHERE ' . $where . "n";

	return $dml;
}