I have three tables as outlined below:

• Primary Table

• primary table key

• primary data

• Secondary Table

• primary table key

• secondary table key

• secondary data

• Tertiary Table

• secondary table key

• tertiary data

Due to server restrictions, I cannot create new tables, which could resolve this, but I must join these three tables.

I need to get data from both Secondary and Tertiary table into the Primary table, but there is no direct link between the Tertiary Table and the Primary one, only with the Secondary.

So I think I need to join the Secondary and Tertiary tables, while selecting only the relevant columns, before I add them to the Primary. Or am I missing something obvious?