Whats the meaning of the next sentence?

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 currenlty is no way to update multiple tables – but this problem is being investigated and pursued.

Taken from : https://wpdatatables.com/documentation/front-end-editing/creating-editable-tables/

--------------------------------------------------------------------------------------------------------------------------------

If I have a wpDataTable which is created from a sql query (from 2 tables), and modifying a parameter from this wpDataTable frontend edition only one table be modified.
            
For example:

//WpDataTable 1
Select * from people p, address a where  p.id = a.id ;
 id | name | age | adress   
  1 | jhon | 40  | street 1   
  2 | josh | 52  | street 2
  3 | kai  | 36  | street 3

In this case, if I modify John´s age (from frontend edition) , and I setted it to 42...

Will be people table updated with new inserted age? (I only want people table be modified).

This is possible? Thankss

Some help?

Hi Aleksandar, you are talking about a view?