Pull data from multiple tables

[TLWP]

Here is the raw FoxPro SQL but it doesn't seem that "USE" is a valid function in DBF Commander. I need all these columns and need them in the specific order they show up. Any way to do this?

USE 'c:\deha.dbf' IN 0 ALIAS DEHA
USE 'c:\DEDA.dbf' IN 0 ALIAS DEDA
USE 'c:\inite.DBF' IN 0 ALIAS INITE

SELECT
DEHA.NUMBER,
DEHA.NAME,
DEHA.INVNUM,
DEHA.INVDATE,
DEHA.CUSTPONUM,
DEDA.ITEMNUM
DEDA.DESCRIPT,
DEDA.QTYSHIP,
INITE.UMSALES,
DEDA.PRICE,
DEDA.EXTENSION,
DEHA.FRTCOST
FROM DEHA
INNER JOIN "DEDA"
LEFT OUTER JOIN "INITE";
ON DEDA.ITEMNUM = INITE.ITEMNUM ;
ON deha.Ordnum = deda.Ordnum ;
WHERE (DEHA.SLP1 like '%GOL%' AND DEHA.INVNUM BETWEEN {^2017-03-18} AND {^2017-03-28})

[Admin]

Yeah, that's right. Just delete all USE clauses and replace aliase names with full paths to the corresponding DBF file, setting an aliase with AS clause. Also, remove all semicolons:

Code: Select all

SELECT
DEHA.NUMBER,
DEHA.NAME,
DEHA.INVNUM,
DEHA.INVDATE,
DEHA.CUSTPONUM,
DEDA.ITEMNUM
DEDA.DESCRIPT,
DEDA.QTYSHIP,
INITE.UMSALES,
DEDA.PRICE,
DEDA.EXTENSION,
DEHA.FRTCOST
FROM 'C:\path\DEHA.dbf' AS DEHA
INNER JOIN 'C:\path\DEDA.dbf' AS DEDA
LEFT OUTER JOIN 'C:\path\INITE.dbf' AS INITE
ON DEDA.ITEMNUM = INITE.ITEMNUM
ON deha.Ordnum = deda.Ordnum
WHERE (DEHA.SLP1 like '%GOL%' AND DEHA.INVNUM BETWEEN {^2017-03-18} AND {^2017-03-28})