UNION within a SmartDataObject

A

andi7171

New Member
Hello,
Is there a possibility to make a "UNION" - equivalent within a progress SmartDataSource.
I have two different tables with user-information. And for an application I need a browser which shows both table-informations within this one browser.
So I searched for UNION within the forum - but I found no solution. The SQL-Syntax for this is:

select customerObjID as ObjID, name1, name2 from dbo_dwh_customer union select agentobjid as ObjID, name1, name2 from dbo_dwh_agent

If you have other solutions - please let me know
Thank You
Andi
 
Displayed data has to have a Data Src. THAT src can be defined to access 2 different tables using the JOIN method. This join will be defined in the data src instance. Allowing the browser to access data from 2 different tables.
 
Hello,
where can I find the "multiple data Source" feature within the browser.
I tried to find some information in the pdf-manual but without success.

Is it necessary to make a "manual" browser-object, or is the multiple feature a standard-object?

Thank You
andi
 
Hi there,

Did you succeed to resolve that problem ?

I have the same problem (Union select) and I don'y know how to resolve it within a SDO.

Thank you in advance,
Razvan Ioan
 
You must log in or register to reply here.
Back
Top