Hi angnut I need your help again! I need to fix the attached query. In the middle you will see that I have a LEFT OUTER JOIN on the subqueries for table x and y. I need this to be a FULL OUTER JOIN, but of course it doesn't work that way. What do I use to return all rows but keep them grouped by id?
Let me know if you can help and thanks!