How to specify an order for table join?

[Jcatcat]

There is a outer join in my query. But it doesn't work.

When using "Show SQL", I found out something like:

select ... from a
join ....
right outer join b on ....
join ....

It seems that the join after my right outer join makes outer join cann't work correctly.

I also test my thought by moving the outer join to the end of the query.

So how can I specify the join order generated by universe?

BTW, I know in Webi we can "Use Custom SQL". But my query is too complicated. It is hard for maintenance if using Custom SQL.

 

[skrandel]

I'm sorry, but the order of the joins shouldn't matter, should it? It may affect our ability to read it, but the optimizer should take care of making it run faster. I've never heard of the join order producing incorrect results.

Steve Krandel
Intuit