I have a table with 10 columns, each of these id numbers relating to a name in another field.
What i would like to do is join another table containg all the names, to each of the 10 columns in the first table.
So basically i am trying to join the same table to 10 fields.
Is there an easy way to do this?
Table 1
-----------
LinkID CatID1 CatID2 CatID3 CatID4 etc
Table 2
-----------
CatID Name
What i would like to do is join another table containg all the names, to each of the 10 columns in the first table.
So basically i am trying to join the same table to 10 fields.
Is there an easy way to do this?
Table 1
-----------
LinkID CatID1 CatID2 CatID3 CatID4 etc
Table 2
-----------
CatID Name