Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost 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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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
Icon for Post Prodigy rankPost Prodigy
4 years ago

Thanks Ashish_Mathur 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    You are welcome.