Toad World® Forums

Syntax error in FROM clause using the query builder


#1

ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

I keep getting this error when using the query builder to link a list of values from an Excel spreadsheet to an Oracle database (I also don’t think the SQL export from the builder to an editor is working correctly – it seems to overwrite other queries I have open in the editor if it exports anything at all)

Also, how do you do left or right joins in the builder? Are these the correct options to choose = ?

Message was edited by: dgrogers