Hello ernie

Thank you for your interest in our plugin.

With wpDataTables you can connect multiple databases, and use SQL queries to create tables from the tables in those databases. You can read more about this in our documentation.

If you know your way around SQL, you can easily create SQL Query based tables, or if you're new to this, you can even try with our query constructor, which acts as a helper, trying to ‘guess’ what you want.

We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.

Alright ernie.

Fair enough. If you need any assistance from us, please let me know.