I have an FM solution that has several instances of the same database and I'm looking at the best way of providing a consolidated view. If at all possible, I'd prefer to limit responses to how to achieve that goal rather than why I've designed it in this way (which is in essence a security issue).
So assuming that there's 3 tables and 3 instances, where each instance of A is identical, each instance of B is identical and each instance of C is identical. There's some form of relationship between A & B and B & C in each instance but (probably) not between the consolidated tables. There is no need to consolidate C (which I'm only saying to make sure I cover all of the probabilities).
What's the best way of going about creating consolidated Tables A & B?
Looking forward to the discussions