Note from the attached 3 screen prints that the SQL Query generator seems to produce data (screen 2) but fails to generate the table (screen 3). I get the same result everytime I try.
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need.
My suggestion when you have queries like this is to make a VIEW in phpmyadmin or any other database management system and see if it will return the desired results.
Note from the attached 3 screen prints that the SQL Query generator seems to produce data (screen 2) but fails to generate the table (screen 3). I get the same result everytime I try.
What is this telling me?
Hi coltding,
Thank you for your purchase.
Please note that MySQL query constructor is not an ‘ultimate generator’, it should be consider a helper that constructs a suggestion of a query trying to ‘guess’ what you want. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated your request is, the higher is the chance that it will not return exactly what you need.
My suggestion when you have queries like this is to make a VIEW in phpmyadmin or any other database management system and see if it will return the desired results.
And after that make a table using query
SELECT * FROM view_name
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables