Hi All,
I have an excluded word list and a list of sentences - I would like to exclude the words in the excluded word list from the sentences
WITH tblExcludeWord AS (
SELECT 'cat' AS excluded_word FROM DUAL UNION ALL
SELECT 'dog' AS excluded_word FROM DUAL UNION ALL
SELECT 'cat' AS excluded_word FROM DUAL
), tblSentences AS (
SELECT 'My cat eats dogs' AS excluded_word FROM DUAL UNION ALL
SELECT 'I like to walk my dog' AS excluded_word FROM DUAL
)
SELECT *
FROM tblExcludeWord, tblSentences
;
Wanted Output
My eats dogs
I like to walk my
Unsure how best to approach this...