Hello,

I've got another problem with sapdb.
Consider the following query:

SELECT role.objectid
FROM T101 role
LEFT JOIN T130 implopc ON implopc.mandatoryobjectid=role.objectid;

, which gives a result with 604 rows. That's OK.

But, if I add the following line:

LEFT JOIN T133 asd ON implopc.objectid=asd.fromobjectid;

, the resulting rows drop to 279. Which shouldn't happen at left join.
I can't see any explanation for this.
Do you?

Thanks,
Agoston Horvath

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to