Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
10 years ago

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.
Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
10 years ago

BhaveshPatel on the basis of No_ feild i have to join these table together to summerize the amount feild.

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
10 years ago

Hi BhaveshPatel hoping that you found the solution for this issue i am waiting for the solution.

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    10 years ago

    Satish_Kumar

    Sorry to keep you waiting. As I was working on the other problem.

     

    Please follow the attached screenshot for the solution.

     

    Step 1: Go to the Table 1 and select Edit Queries, Select the Merge as a new Queries.

    Merge Queries

    Step 2: Expand the newly created column and Select the amount including Tax.

    Expand the newly created column

    Step 3 : Final Results

    Final output