I have created a multi-site Drupal 7 in my localhost environment with a main-site and a sub-site in it with a single database, with table names of sub-site prefixed with 'sub_'. If I tried editing the setting.php of sub-site, altering 'prefix' value in database array to a shared table I cant access the sub-site own table. I need the sub-site to access both shared table and its own table. So that if any content/content-type created in main-site has to be reflected in sub-site.But the content/content-type created in sub-site should not be reflected in main-site.
How to achieve it?