Forum Discussion

Mariam1991's avatar
Mariam1991
Icon for Helper II rankHelper II
9 years ago

JOIN 3 tables

Hi everyone; I have 3 tables i need to join its to calculte distinct id  in table A distinctcount(tableA[id]) but the juncture will be between 3 tables  as below: tableA[id]=max(tableB[id]) tableB...
Need Help
Mariam1991's avatar
Mariam1991
Icon for Helper II rankHelper II
9 years ago

i don't know how but my aim is to calculate distinct id in table A taking in consideration the juncture between 3 tables 

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Mariam1991,

 

Could you post your table structures with some sample data and your expected result? So that we can better assist on this issue. :smileyhappy:

 

Regards