There are tables mapped using join ..
You need to match another one, but according to the column that you first need to format, that is, remove all characters from it, except numbers and Latin letters. Such a fraud it will be similar to the one that will be attached ...

Is it even possible to do this?
Tables

as a result, I would like to get a table of the following form: Connected table

  • I'm afraid you'll need a lot of nested functions replace each of which will remove one character and of course all the characters to be deleted will need to be explicitly specified - Mike
  • I understand. Tell me how to write a request for these functions correctly if you know - Yuriy Rusin
  • replace(replace(art_article_nr,' ',''),'/','') , etc. - Mike

0