Forum Discussion
Count Increased after Left join
Hello all, I have two tables Cntry, parts In parts there are 30 columns and in cntry only 2 columns. I am doing Left join based on cntry_abb matching column in both tables Left tables is Parts a...
Anonymous if you are linking from cntry table to part tables it will increase the count since there are duplicate in part table,
but if you are doing from part table to cntry table then the count of parts table will remain the same. It is very basic thing, not sure what is the confusion here.
