I dont know how to explain what I need. So be patient .
I have three tables :
Parent Table
Children Type A
Children Type B
Both types of children share the Parent ID. For specific gadget I need to take a column of Children A in Children B .
So What I am trying to get it is something like this.
[Parent ID].[Children A].[Column A] WHERE Children A[Parent ID] = Children B [Parent ID]
Regards,
Geovanni Rojas
So you want the value of the Column A column in the Children A table for all rows of Children A whose Parent ID also occurs in a row of Children B?
SELECT(
Children A[Column A],
IN([Parent ID], Children B[Parent ID])
)
THIS NOT WORK , LITERALLY IT IGNORES THE CONDITION OF SAME PARENT ID , ANY IDEAS ?
You need to state your requirements more clearly. I had to guess what you wanted, and you shouted at me that I was wrong.
Sorry, I did not try to shoot you , it just I had the uppercase activate.
I just figure it how to do it. I will write my code just if someone need it.
SELECT(Children B[Column desire], [_THISROW].[Parent ID]= [Parent Id])
With your code I was getting a list, the big differences made the โThisrowโ that gives me a list but just of the related .
Thanks .
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |