Hi everyone,
I'm dealing with a database design that is hardly what I would suggest but here is the delima.
I have three tables and each one of these tables have 3-4 Date Columns are based on
certain activities. I have to show in the Report Author report these dates but under different
rows but same columns.
I'm trying to findout how I can establish a Union or Join within Framework Model Subject Query to
have all showing as rows under the same columns. The column names are different in the tables
but they present the same information on the report.
I have attached a snapshot showing what I'm trying to do with two tables.
Please help if you can.
Thank you
Quote from: gosoccer on 05 Sep 2015 06:49:11 AM
Hi everyone,
I'm dealing with a database design that is hardly what I would suggest but here is the delima.
I have three tables and each one of these tables have 3-4 Date Columns are based on
certain activities. I have to show in the Report Author report these dates but under different
rows but same columns.
I'm trying to findout how I can establish a Union or Join within Framework Model Subject Query to
have all showing as rows under the same columns. The column names are different in the tables
but they present the same information on the report.
I have attached a snapshot showing what I'm trying to do with two tables.
Please help if you can.
Thank you
Hi,
Sounds like you need to define a query set? Select two of the tables then go to Actions > Define Query Set to union them. Take the results of this and do the same with the third table.
Cheers!
MF.