M
modhorat
Guest
I've been using SQL on a Progress Database (I'm sure it uses SQL92)
I'm receiving the error:
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...
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...