I have a table with a ranking keywords and join another table where the keyword exists but when I apply an outer join, it only returns the inner join since there are multiple matches to 1.
What I want:
I tried several different joins but it doesn't return what I want. It always returns an inner join.
You can achieve your desired output by joining each table separately and then applying union on those results.You can try the below query :
Query:
Output: