Yes, it's a known issue with QL compiler. We just don't do outer joins at the moment. There is a bug report on it.
Thanks for the reply.
Do you know when this issue will be addressed?
No. While I agree we do need it I have other priorities. You are welcome to help.