I have an object type A and object type B with the following properties
A.id
A.property1 = reference to object B
and also
B.id
B.property1
i want a filter that returns in a table
A.id, B.property1 where B is A.property1 , like the same concept of making a join in sql but i cannot find how to do it.