If I run a simple sql statement it works ok.
sql = "select * from table1;" // -- works
If I add some type of join to the sql statement, it fails with error:
sql = "select t1.col1, t1.col2, t2.col2 " + _
" From table1 t1 " + _
" inner join table2 t2 on " + _
" t1.col1 = t2.col1 " + _
" Where t1.col2 <> t2.col2; "
An exception of class DatabaseException was not handled. The application must shut down.
Exception Message: near “select”: syntax error
Exception Error Number: 1
Typically when I run into this error I figure out a different way to solve the problem. In this particular case I’d like to find - if possible - the proper solution to letting sql answer the query instead of me coding around the error message.
I’m open to suggestions.