I don't know anything about dBase, but I am trying to pull data out of a customer's old Dbase database. It's a set of .DBF files. I am using ODBC and DBeaver to pull out data, but when I Join more than 2 tables I get an error.
Select *
from tableA
Left Join tableB on tableA.Key = tableB.Key
Left Join tableC on tableA.LINK = tableC.LINK
The error is:
SQL Error [37000]: [Microsoft][ODBC dBASE Driver] Syntax error (missing operator) in query expression 'tableA.key = tableB.key LEFT JOIN tableC ON tableA.LINK = tableC.LIN'.