It's of course a bug and will be fixed with one of the next releases. As a workaround you could use an inner join as Sven already mentioned.
We use the MS SQL Server as well as SAP DB.
Our previous projects ran under SQL Server and we always used LEFT JOINs because they are faster than INNER JOINs.
So we have to change all our statements to a slower variant... Of course we would appreciate a bug fix in SAP DB than doing that. ;-)
Are you able to say when it will be fixed? (I just migrated to Win32 SAP DB and ODBC 7.4.3.27)
Best regards,
Benjamin Lukner trinomix GmbH
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
