Hi there,
I've had a good search through the forums but can't find anything that covers this kind of join;
select *
from parent p
join child c on (c.from_parent_id = p.parent_id OR c.to_parent_id = p.parent_id)
I need to be able to specify the following expression somewhere;
ChildFields.FromParentId == ParentFields.ParentId | ChildFields.ToParentId == ParentFields.ParentId
In the relation/join.
Is such a relation possible in code?