> but both will get you a very long ways.. MySQL (and MariaDB) wont let you refer to temporary tables more than once in the same query. http://dev.mysql.com/

> but both will get you a very long ways.. MySQL (and MariaDB) wont let you refer to temporary tables more than once in the same query. http://dev.mysql.com/doc/refman/5.0/en/temporary-table-problems.html http://dev.mysql.com/doc/refman/5.0/en/temporary-table-probl... I am not sure that was a very long way when I needed this for an app I was working on.