Join

Left

Table

Column

Intermediate table

Use

Table

Subject column

Object column

Right

Table

Column