You can, edit your query by custom sql and use union all. I hope the referred link could help you.
1 of 1 people found this helpful
Thanks TG for your response,
yes there are other ways to do so, but i wanted to understand why it does not allow me to have full outer join.
my data source is MySQL
MySQL doesn't have syntax keyword FULL OUTER JOIN. You have to use combination of LEFT and RIGHT JOIN to obtain full joins.