OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Problem with LEFT JOIN, WHERE and LIKE (Error in SAP DB?)

From: Sven Köhler (skoehlerupb.de)
Date: Fri Jul 04 2003 - 07:51:54 CDT

> !
> ! 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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general