Forum Discussion

Oros's avatar
Oros
Post Prodigy
4 years ago
Solved

Relating different tables

Hello,   Would anybody know how to build this results table below using the product discount, customer and sales tables?  How do you relate these 3 tables and what formula/statement to use?  Thanks...
Need Help
Oros's avatar
Oros
Post Prodigy
4 years ago

Hi Ashish_Mathur ,

 

Thank you for your quick reply.  In merging table 3 into table 1, what do you mean by based on Product # AND Discount Type column?  How do you achieve this merging using in a query, based on 2 columns? Thanks again.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

In the Query Editor, select Merge queries and then select the common columns of both tables.

  • Oros's avatar
    Oros
    Post Prodigy
    4 years ago

    Thanks Ashish_Mathur 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      You are welcome.