Skip to Content
0
Sep 20, 2023 at 04:50 AM

How to union query in normal table and derived table

86 Views

Hi all,

in the BO report, i have used a normal DB table and joined build the report. after a few days user came back with a new Chang asking the union for the new logic query. (tables and join everything is different)

in the same data provider needs to show the old and union along with updated SQL

Exam:

Data provider SQL shows like below

Normal table (existing DP query)

Union

New logic query (derive table)

so how to build this scenario

help on this

Thanks