'How do I Join 3 tables in Dbase?

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'.

dbase


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions