I have two table in Mariadb.
Address: Id | city | street | number | key2_a
Product: Id_prod | name | key2
I would like join TAB address and TAB product:
Id | city|street|number|key2_a|id_prod|name|key2
I'm making a query:
select * from (t1., t2., UTL_MATCH.EDIT.DISTANCE.SIMILARITY(t1.key2_a, t2.key2) SIMILARITY_PERCENT, row_number() over (partiom by t1.id order by UTL_MATCH.EDIT_DISTANCE_SIMILARITY(t1_key2_a, t2.key2)desc)rn_rank from adress t1 join product t1 on UTL_MATCH.EDITSIMILARITY(t1.key2_a, T2.key2)>50)
My error in attachment.