Hello,

Our Plugin's SQL feature is not the same as a DB Management Tool and it has certain limitations.

First, I will try to advise on potential small modifications which you can try, as it does seems as a simple Query, but our Parser probably struggles with one or more details in your syntax.

select t1.date, t2.date
from sales_data t1, sales_data_2 t2
where t2.date = t1.date limit 10;

1. It seems you are renaming the sales_data to t1 and sales_data_2 to t2 in the SELECT part.
Can you try to just call the table names without trying the ALIAS for this part, see if that helps?

Try something like :

"

SELECT sales_data.date AS date1, 
sales_data_2.date AS date2

FROM sales_data, sales_data_2
where date1 = date2

"

Or try with a JOIN function.

For example, an INNER JOIN, if you wish to return only matching records from both tables on your set condition :

SELECT sales_data.date AS date1, sales_data_2.date AS date2

INNER JOIN sales_data_2 ON date1 = date2


2. Remove the semi-colon from the end of the Query ;
3. Remove the LIMIT statement if possible - because, if you enable the server-side processing, our Plugin automatically adds this to the Query in the background.

4. Disable server-side processing, if the table has less than 2 thousand rows.
In some cases, this can help, because when server-side is enabled, our Plugin sends a more complex Query to your DB;
While when the server-side is disabled, then it tries to simply call the data as you write it from the Query.

5. And we also need to avoid having the same column name called more than once in the Query.
When this happens, our Plugin only calls the first instance and ignores any 'duplicate column headers'.

You can try the ALIAS for the columns as I did above, see if this helps.

If none of this works, here are more details, and possible workarounds :

Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types

-

But you can also check these points to save time if you wish.

SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.

Some of them are disabled for security reasons.

Filtering, sorting, and search may not work properly if you include:

• Accent graves ( ` ) around the table name
• JOIN functions
• UNION functions
• CONCAT functions
• sub-queries

If none of that helps,

you can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.

 If you need help with that, you can see our video, where we show an example of using View in our plugin.

Let me know If that helped.

Thank you