Re: ORDER BY not working with UNION ALL

2017-05-10 Thread Sergey Soldatov
Well, even if you don't use family, you will get an error that column date_time is undefined. Consider the result of UNION ALL as a separate table and ORDER BY is applied to this table. You don't have column date_time there. Don't forget that UNION ALL may work with different tables, so there may

ORDER BY not working with UNION ALL

2017-05-03 Thread Cheyenne Forbes
I get "Undefined column family. familyName=f" whenever I run the following query,it works without the ORDER BY and works with the ORDER BY if its not a union and just one select statement SELECT p.name FROM person p JOIN friends f