SQL inner join from field defined table?
- by Wolftousen
I have a, currently, a total of 6 tables that are part of this question. The primary table, tableA, contains columns that all the entries in the other 5 tables have in common. The other 5 tables have columns which define the entry in tableA in more detail.
For example:
TableA
ID|Name|Volumn|Weight|Description
0 |T1 |0.4 |0.1 |Random text
1…