Hi there
I know about dynamic relationships that they are used when a relationship is not defined and we need to join two tables. I need to implement a query like this:
select parentOrder.Name,parenOrder.Amount ,childOrder.amount,childorder.Id
from
Orders parentOrder inner join Orders childOrder on parentOrder.Id=childOrder.ParentOrder
But I have two questions:
-
How do I join two tables specifically telling the columns on which they are to be joined
-
How do I retrieve column values of the related table