Could you guys support Views?
I want to be able to have a view that selects data from 2 tables with same columns.
I actually managed to do this by first creating a section in CMS with the columns that I wanted, then with phpmyadmin, I dropped the table and created a view to replace the table.
Works great except that CMS complained that my view was not a table, line 213 of lib/database_functions.php, once I removed the die statement, everything worked fine.
mysql_query("ALTER TABLE `".mysql_escape($mysqlTableName)."` $addFieldSQL") or die("Error adding fields to '$mysqlTableName', the error was:\n\n". htmlspecialchars(mysql_error()));
Would be a nice feature for a future release.