I have got tables.
Table 1: Parties
PartyID | PartyName | Email
Table 2: Inwards
Inward ID | IDate | FromID | ToID | ....
My requirement is that I need a list that would display the output as
InwardID | IDate | FromParty | ToParty | ...
How do I use get the PartyName from PartyName, in the two columns namely FromParty, and ToParty
Using Inner Join would fill in either of FromParty, or ToParty.