I need to update on a table A by taking information from table B using inner join with wildcard to compare a snippet of content and if found in B, load a column in A. To just test this join I made the select below:
SELECT
vinhos.*
FROM vinhos
INNER JOIN 'winemag-data-130k-v2'
ON '%' + vinhos.DESCRICAO + '%' LIKE '%' + winemag-data-130k-v2.winery + '%'
But unfortunately it is not working. How can I perform the update using this query (the select was only test)?