Hi Larry

That is how the plugin works. It is not a database management tool, and it shouldn't be treated like that. It is a simple datatable plugin, which allows you to use some SQL functionalities, but not all.

Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types

SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.

Some of them are disabled for security reasons.

Using variables ( @ ), stored procedures and nested queries is not supported.

Our developers will be working on resolving the issue of editing multiple tables in a query, but at the moment it cannot be done, and there is no workaround.

Hello again Larry

You can create a view from a hundred tables, and display that view through an SQL query based table. However, you cannot edit more than one of those underlying tables if you pass the proper ID.

When using the SELECT statement, you can create a table from multiple tables, but they have limitations that were described in our documentation and my previous responses.

The issue we're having with filtering, sorting, search and editing tables with JOINS, and views that come from multiple tables exists from the beginning, and there's no estimate when this will be fixed. Our developers are working on it, but SQL is a complicated language, and the same functionalities of PHPMyAdmin, or other database tools will probably never be achieved.