! ! It seems like the WHERE statement only affects the MyArt table ! and NOT the whole join. Failure or feature?? !
Bug in SAPDB kernel.
If you have a WHERE clause that doesn't allow NULL columns, than the LEFT JOIN will become an INNER JOIN. So you might want to choose an INNER JOIN.
What's your opinion about this behaviour?
There were a few bugs related to LEFT JOINs, this must stop. I'd also like to know, which version of SAPDB you're using.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
