Business objects and equivalent sql minus/intersect/union/union all

Jul 2, 2023 9:11AM

Summary:

Content (required):

Hi all, I would thank any help with the following.

Business objects in VB are great to CRUD operations, but I cannot find an easy way to apply basic sql operations, as said in Question.

Example :

I have table 1 and 2 with same structure (employees). I would like to know for example the common employees in both tables (intersect operation).

Has anyone some workaround for this?

Currently the only option I have worked out is looping in resultsets, which is time consuming and sometimes not feasible.

Business Objects Equivalent to DB-views would be an option, but I have not found doc. about this.