The following SQL connection works
SQLEXEC(gnConnHandle, 'SELECT COMPANY, POLICY FROM POLICY', 'accessquotes')
However the join does not?
SQLEXEC(gnConnHandle, 'SELECT P.COMPANY, P.POLICY, C.NAME FROM POLICY P, COMPANY C WHERE P.COMPANY=C.COMPANY', 'accessquotes')
I am sure my table and column names are correct.
Best Regards,
Lee Roy J. Pitre, Jr, AAS, BA, MS
Pitre Computer Consultant & Associates
http://pitres.us