How to do an Impossible Join with String Split Use STRING_SPLIT() to join two tables Click here to read the article
