SQL (in Progress Database): E_FAIL status on multiple Left Joins

I've been using SQL on a Progress Database (I'm sure it uses SQL92)

I'm receiving the error:

Data provider or other service returned an E_FAIL status
​

I believe it has something to do with my SQL query, as the same tables work in other reports with basic select queries

The code is as below:

Select * FROM

(Select * FROM

(Select "dtrs-AccountBal", "dtrs-AccNumber", "dtrs-AccName", "dtrs-salesmanNumber"
FROM pub."dtrsMaster"
Where ("dtrs-AccountBal" > 10 OR "dtrs-AccountBal" < -10)) AS DTRS

LEFT JOIN

(Select "dtrs-AccNumber", Max("dt-documentNumber") AS "InvNo"
From pub."dtrsTransactions"
Where "dt-move" = 'INV'
GROUP BY "dtrs-AccNumber") AS DBTRTRAN

ON DTRS."dtrs-AccNumber" = DBTRTRAN."dtrs-AccNumber") AS TEMP

LEFT JOIN

(Select "sm-customerName", "vm-datesold", "vm-invno", "vm-serial", "vm-stockNumber"
FROM pub."stockMaster"
Where "vm-sold" = 1) AS STK

ON TEMP."InvNo" = STK."vm-invno"


Can anyone assist me?

Thanks in advance

Continue reading...