Combine couple of tables into one table by using references

[Leo Leo]

Dear Experts,

I have two tables. Table A which has block A1 (ie row 1 to row 15) and block A2 (row 16 to row 30). Table B has block B1 and block B2.

Table A and Table B are provided by different vendors.

I want to have a single Master table ie combine A1 with B2 but I dont want to load in all the values from A1 and B2 into this Master table. This will take up extra physical memory. Possible to have pointers or reference such that when i query for certain date, this Master table will automatically load in Table A's A1 or Table B's B2.

Thanks
L