Please confirm my understanding about join table concept:
Consider three tables Parent A,Join A,parent B
Parent A is related to Join A using Id1
Join A is related to parent B using Id2
In the layout, the main table associated is Parent A
If I want to fetch related records from parent B, even though the relationship is not established directly, as the join has the unique combination of Id 1 and Id 2 for each record, Using these key values, related values will be fetched from parent B using the portal tool.