SQL

inner join multiple conditions

-- Use "AND" operators
UPDATE T1
SET T1.Inci = T2.Inci 
FROM T1
INNER JOIN T2
ON T1.Brands = T2.Brands
AND T1.Category= T2.Category
AND T1.Date = T2.Date