also u have to ensure that the aliases of everything your selecting must match between the top select and bottom select. these aliases is what you will put in your order by