When the synthetic keys are avoided using AS key, resuts produced seem in correct
Dear All,
I have linked two tables to produce results as I wanted. In the process, I am getting synthetic keys. (Branch_code & ME_CODE). But with synthetic keys, the results produced are ok. But I prefer expected results without the synthetic keys. I did a left join too hoping to avoid synthetic keys but nothing happened. Will some one see where I have gone wrong & please correct me to get the expected results!
Maybe you should create a composite key With the two Fields, Field1 &'-'& Field2 as Key. Left Join is not the best way to reduce synthetic keys, it better to rename the Fields. And sometimes Synthetic key is not as bad as the rumor.
Thanks for your reply. Dear I renamed one of the field which helped me to avoid the composite keys but results produced are in correct. But when it is as it is with synthetic keys result are good. Why is that?. You could see that if I rename the Branch code, Refund value shows abnormally high which is not the actual case.
