Forum Discussion
Solved
Create table getting data from table hosted in another query
Hi all, I need to create a table with 3 columns getting data from another tables that are in another queries. I would like to use advanced editor to create this table. Example: Column...
Hi, Please follow the Image:
If you need a New Merge Table Select Merge Queries as New
Is there a relationship between these different tables?
Hi,
I have the column Product Name that I can use to create the relationship.
Follow the sample about the tables:
Table 1:
Product Name Contracted Product1 100 Product2 200 Product3 300 Product4 400 Product5 500 Table 2:
User Email Product Name Computer Last Logon User1 [email protected] Product1 Computer1 User1 User2 [email protected] Product3 Computer2 User2 User3 [email protected] Product5 Computer3 User3 User4 [email protected] Product2 Computer4 User4 User5 [email protected] Product4 Computer5 User5 User6 [email protected] Product2 Computer6 User6 User7 [email protected] Product4 Computer7 User7 User8 [email protected] Product1 Computer8 User8 User9 [email protected] Product5 Computer9 User9 User10 [email protected] Product5 Computer10 User10 User11 [email protected] Product1 Computer11 User11 User12 [email protected] Product5 Computer12 User12 User13 [email protected] Product2 Computer13 User13 User14 [email protected] Product5 Computer14 User14 User15 [email protected] Product4 Computer15 User15 User16 [email protected] Product1 Computer16 User16 User17 [email protected] Product3 Computer17 User17 User18 [email protected] Product2 Computer18 User18 User19 [email protected] Product4 Computer19 User19 User20 [email protected] Product1 Computer20 User20 Table that I need:
Product Name Contracted In Use Product1 100 5 Product2 200 4 Product3 300 2 Product4 400 4 Product5 500 5 I need do drill down in the last column from in this last table.
Tks,
Hi, Please follow the Image:
If you need a New Merge Table Select Merge Queries as New
Hi Vvelarde
In this example you merger 2 tables.
Is it possible merge another one using the same column name?
Then we will use 3 tables.
Tks!!
