1 of 1 people found this helpful
If you apply inner join you you will get only common rows.
But if you want total no:of Stores from 'store_master', make ur 'store_master left side table with the other table on right side. Then apply 'Left Outer Join'.(use JOINs at data source level) Doing so u will get all the common rows as well as the extra rows from the store_master.This will eventually give you total details from store_master.
If not u can as well try blending