I have a problem involving 3 tables in a Universe that i am currently working on, the platform is DB2.
Basically my three tables a b and c are connected as follows, one of three fields in table a will be connected to a single field in table b... And a single field in table b will be connected to a single field in table c.
At the moment i have a single table for a and three tables for each of b and c (the original and two aliases) to represent each of the possible joins to table a.
I was hoping to have a single table C joining into all three table b's - is this possible and how should i approach it??
Also is it worthwhile trying to eliminate all of my aliases in these three tables?? As i would like to create a report that contains information on all three aliases of b and c...
Basically my three tables a b and c are connected as follows, one of three fields in table a will be connected to a single field in table b... And a single field in table b will be connected to a single field in table c.
At the moment i have a single table for a and three tables for each of b and c (the original and two aliases) to represent each of the possible joins to table a.
I was hoping to have a single table C joining into all three table b's - is this possible and how should i approach it??
Also is it worthwhile trying to eliminate all of my aliases in these three tables?? As i would like to create a report that contains information on all three aliases of b and c...