I have setup an odbc connection to a pervasive database. I can connect and query each table individually. When I attempt to use a sql inner join I end up with no results displayed. I have run the query using ms query on the odbc connection to the database and it works fine. Any other queries I try on the db/odbc work fine as well. Its only the inner join command. If I copy these tables into mysql and perform the query using the mysql connection it works as well. Can anyone provide insight on this issue?
Example: Non join works fine
SELECT ardoc.CustId, customer.crlmt, customer.billname FROM customer, ardoc where ardoc.Custid = customer.Custid
Example: Join doesn't work
SELECT ardoc.CustId, customer.crlmt, customer.billname FROM FROM ardoc inner join customer where ardoc.Custid = customer.Custid
