How to fetch data values from different tables
I want to fetch values from two or more external tables of a DB and display them in a grid/table format in the UI. How can i do that
***Updated by Moderator: Marissa to update categories***
Accepted Solution
Union in SQL means you are getting results from one table and appending the results from another table to the initial results (all this in DB) and then returning the full set of results.
Join in SQL means you are using a set of conditions to get columns from one or multiple tables (not appending rows)
Accepted Solution
Union in SQL means you are getting results from one table and appending the results from another table to the initial results (all this in DB) and then returning the full set of results.
Join in SQL means you are using a set of conditions to get columns from one or multiple tables (not appending rows)
Union operation cannot be achieved through report definition (Click here). One should write custom SQL and use it from RDB-List method to achieve this scenario.
Can you please detail the steps on how to implement union functionality in RDs unsing 7.2?
We've a req to pull data from 4 different underlying tables and consolidate the result sets into one.
We intent to use only one RD to achieve above functionality.
Thanks