Forum Discussion
how to join two tables.
Hi All,
i want to know how can i join two tables with a common feild to make a resultant table.
11 Replies
You can use Merge Queries option in Query Editor and can use Left Outer Join for the combined table.
Or
You can Drag and Drop the relationship arrow from the Table 1 to Table 2 between two common fields.
In this way, You can use the Relationship flow logic between tables and You would not create much more flattened tables. This approach is suitable in line with the best methodologies to create data warehouse.
Hope this has cleared your understanding.
BhaveshPatel Actually i have created realtionship between the tables but i have to summerize the amount feild based on id which is in different table that why i need a join to create a new resultant table.
but i will try the merge query.
Love to recreate a solution for you if you can post sample data and expected output.
