I am looking for Joomla extention with the following functionality from the front-end:
- select some columns from several tables in the MySQL database (for example, I have two tables: one with columns 1 2 3 4 5, another one with columns 2 a b c d e. I need to select data from columns 1, 2 (where a = x);
- create a table with the selected data;
- change cells (better with possibility of rights management);
- export a table with the selected data to Excel or csv file format.
Is it possible to use Droptables in this way?