Forum Discussion
Helper Vhow 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
- BhaveshPatel
Super User
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.
- Satish_Kumar
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.
- BhaveshPatel
Love to recreate a solution for you if you can post sample data and expected output.
