SQL INNER JOIN not working from PHP application to take data from progress database

any help appreciated, first time trying this.

My SQL INNER JOIN not working from PHP application to take data from progress database.

My code for the SQL query is:

$sql="SELECT * from pub.table1 inner join pub.table2 on table1.nsnref = table2.nrnref where table1.nsscac <> '' and table1.client = 'tgl' and table2.nrname matches '*" .$_POST['suggest']. "*'";


The table names have been changed to protect the innocent. If I run any SQL query without a join it returns through ajax call very quickly, but joins not working for me

Thank you in advance for any assistance.

Continue reading...