Hi, Oliver.

Thanks for reaching out to us.

-

1. If you mean to join/merge data from multiple tables, yes - this is possible with our SQL based Tables.

In SQL Query based Tables, you can make a custom SQL Query, and use SQL JOIN function,

but then you won't be able to edit that table.

You can see more about editable tables in our plugin here,

we pointed out some limitations :

• Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
• Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” page can be edited.
• Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.
• MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.

-

So, the only way to have columns from other tables and have it editable is with our built in option "Foreign Key Relations".

This can allow you to join data from multiple dataTables while having "single value selectbox" for editing.

2. To limit Editing for specific user roles for specific tables,

we have this option, in back-end of the table , in the Editing settings,

you can choose which roles will be able to edit.

So if you set only Editors in "Editor Roles", then only users with role Editor are able to edit this table.

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions. 

Hi, Oliver.

Yes, you can have all these tables as SQL Tables in your database, and they will be editable by our plugin,

as long as you follow what we noted before, for the limitations on Editing.

So, if you make 5-6 tables in your Database, and have each table have its own columns and rows,

and if you call a Query like : SELECT from Table 1,

then this table is fully editable.

-

If you use an SQL JOIN to join data from Table 1 and Table 2, then it will not be editable.

But you can use our Foreign Key feature to pull multiple columns from multiple tables into one consolidated table,

and the Foreign Key Columns can be editable, as "single value selectbox".  It pulls all the unique available values from the foreign table so user can select one of the values for editing.

Please check more details with our example here, where we made several tables and then made a consolidated one that pulls data from all of them.

https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/

Let us know if you have any questions.