[PROGRESS]Syntax error (7587)

[ganjass]

SQL Driver Name is : PGPRO915
SQL Driver Version is : 03.60.0000
SQL Driver Supported ODBC Version is : 03
SQL DBMS Name is : PROGRESS
SQL DBMS Version is : 09.1D

Hi All I'm trying to run reports using the following query through crystal reports V10:


SELECT "debt"."debt-code", "debt_trans"."rz-code", "debt"."client-code", "debt"."dt-cliref", "debt"."dt-pdtodate", "debt"."dt-curbal", "debt"."dt-debtval", "debt"."dtCondition", "debt"."dt-datinstr", "notepad"."nt-notepad", "notepad"."nt-date", "debt"."rz-code", "notepad"."nt-time", "debt_trans"."tran-code", "debt_trans"."tx-date", "client"."cl-name", "debtor"."dr-name", "debtMaster"."dmAccountNo"
FROM {oj (((("PUB"."debt" "debt" LEFT OUTER JOIN "PUB"."debt-trans" "debt_trans" ON "debt"."debt-code"="debt_trans"."debt-code") LEFT OUTER JOIN "PUB"."notepad" "notepad" ON "debt"."debt-code"="notepad"."debt-code") INNER JOIN "PUB"."client" "client" ON "debt"."client-code"="client"."client-code") INNER JOIN "PUB"."debtMaster" "debtMaster" ON "debt"."MasterNumber"="debtMaster"."MasterNumber") INNER JOIN "PUB"."debtor" "debtor" ON "debtMaster"."MasterNumber"="debtor"."MasterNumber"}
WHERE "debt"."dt-curbal">0 AND ("debt_trans"."tx-date">={d '2004-11-01'} AND "debt_trans"."tx-date"<={d '2005-02-23'}) AND "debt_trans"."tran-code"='SC1000' AND "debt"."client-code"='W&D' AND ("debt"."rz-code"='C' OR "debt"."rz-code"='ca' OR "debt"."rz-code"='E' OR "debt"."rz-code"='H' OR "debt"."rz-code"='Q')
ORDER BY "debt"."client-code"

And I'm getting the [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)

I've searched the web and not found any conclusive info

Thanks in advance

 

[ganjass]

If i take out the left joins i don't get the error message.

But this kind of limits me!!

any ideas??

Cheers

 

[teknogeek9]

Do your inner joins first and then your left outer joins. In Crystal, under Database Expert, click on order links and then drop the outer joins to the bottom.