I have 2 tables joined by a lookup table that crosses both of them. Provider Extract is the crossover table, only one instance. I have billing Sample which has many Provider Names with billing data. Then I have Productivity which is just also repeating providers but I only want one instance of this, no aggregation. I want to Join them somehow so can I aggregate Billing Data but I only want one instance of Productivity Data. I cannot seem to get them connected and work. Sorry if I am not clear I can clarify.
1 answer
Hi Wieslaw,
It looks like you're relate the BillingSample table by the wrong column --
the [Bill Area Id] instead of the [Bill Prov Id]. I suppose it's by mistake.
Yours,
Yuri
