I am trying to copy data from a remote database into my own local database. Both (databases) have same names but different ip? !--help--!

if posiable give code example i tryed

insert into with select

but how should i name the table on different host address ...