Business objects and equivalent sql minus/intersect/union/union all
Summary:
Business objects and equivalent sql minus/intersect/union/union all
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.
Tagged:
0