fetching externally hosted db's table from within the local mysql server

Let's say we have a mysql database on localhost with table A and table B. Is it possible to fetch details from a 3rd party mysql server to which we have login info and which allows external access? Let's say there are 3 tables in the database we can connect to - table A2, B2 and C2. How do you fetch the rows from table C2 and make it VIRTUALY accessible (as table C) from within the original mysql server (just like A and B), just like if it was hosted on it?