Table Joins

Hi,

Thanks for contacting us here about this extension.

Built a custom Joomla user table, so can capture additional user data.
Want to create table listing that shows joined data from both the Users table and the Additional User Data table. Tables are joined with foreign key in Additional User Data table.

Can DropTables do the join?

Yes, you can display the joined tables in your database with our Droptables.

Does DropTables have live link to database, so that when record is updated then DropEditor shows new values?

Droptables always takes and update the newest data in your database.
Note that: you can not edit directly your database in Droptables.

Please go here for more information: https://www.joomunited.com/documentation/droptables-documentation#toc-vii-tables-from-database

Hope it helps!
Cheers,

Thanks, bought

On Fri, Jul 26, 2019 at 11:00 PM JoomUnited <[email]This email address is being protected from spambots. You need JavaScript enabled to view it.[/email]> wrote:

























New Reply Added

Assistance replied to the discussion Table Joins

















Hello,


This is a notification to let you know that Assistance has replied to the discussion on the site. You may find the snippet of the reply below:








Hi,



Thanks for contacting us here about this extension.

Built a custom Joomla user table, so can capture additional user data.

Want to create table listing that shows joined data from both the Users table and the Additional User Data table. Tables are joined with foreign key in Additional User Data table.



Can DropTables do the join?

Yes, you can display the joined tables in your database with our Droptables.

Does DropTables have live link to database, so that when record is updated then DropEditor shows new values?

Droptables always takes and update the newest data in your database.

Note that: you can not edit directly your database in Droptables.



Please go here for more information: https://www.joomunited.com/documentation/droptables-documentation#toc-vii-tables-from-database



Hope it helps!

Cheers,







Read this discussion