Hi All,

Hope all are doing great. I have a small query regarding the Join function to create view. I have two table in which table 1 is having 40k records and table 2 is having 40k records. But when i am joining the both to create view, it is showing 47k records. Please note that i am combining table using two common column in both, one is “Calendar_Date” and one is “Personal_ID”. In some cases few Personal ID has duplicate records for each month.  So while creating the view the, these duplicate records gets multiplied . Hence the total records exceeds 47k. How to make it same 40k records which i am having in each table.

Any help would be highly appreciated. 

Regards,

Sagar

​Hi All,Hope all are doing great. I have a small query regarding the Join function to create view. I have two table in which table 1 is having 40k records and table 2 is having 40k records. But when i am joining the both to create view, it is showing 47k records. Please note that i am combining table using two common column in both, one is “Calendar_Date” and one is “Personal_ID”. In some cases few Personal ID has duplicate records for each month.  So while creating the view the, these duplicate records gets multiplied . Hence the total records exceeds 47k. How to make it same 40k records which i am having in each table. Any help would be highly appreciated.  Regards,Sagar  Read More

​