For last point, Majorly Join can club 2 tables into one. But, where keep can allow same in First table and Second table we are doing some calculations for business fact / Transaction logic.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful