Bascially there is only one column on which we can join each of these tables which is BID.And for each BID, the table4 has multiple rows. There are 5 million records in table4 and 3 million each table3 and table2.